Conditional formula on date field in Grid view

Topic Labels: Dates & Timezones
528 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi All-

I am looking to have a conditional field in grid view so that if we are approaching an expiration date, the field will change color according to how soon- e.g. using (TODAY) red if 30 days from expiry, yellow 60 days, green 90 days. So far, I am not having luck with the IF formula in the condition field.

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator
IF({Expiration Date},IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=90,'🟩',IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=60,'🟨','🟥')))