Hi

I was excited to hear this announcement but now when I try to use a formula column as a lookup column, I can't seem to. I was hoping to get around the problem of Zoho Reports not supporting lookup on date column by converting data into number using convertdatatype function and then doing lookup on it but I encounter the same message as earlier- that formula column can't be changed to a lookup one.

Not sure if my understanding of the announcement is wrong or I'm not doing the lookup properly.

Appreciate if someone can help.