Skip to main content

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.

IF({Expiration Date},IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=90,'🟩',IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=60,'🟨','🟥')))

Reply


Terms & Conditions