Skip to main content

Conditional formula on date field in Grid view

  • May 9, 2023
  • 1 reply
  • 11 views
M
Forum|alt.badge.img+1
  • MLH
  • New Participant

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

    Matthew_Carrano
    Forum|alt.badge.img+14
    • Matthew_Carrano
    • Known Participant
    • 34 replies
    • May 9, 2023
    IF({Expiration Date},IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=90,'🟩',IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=60,'🟨','🟥')))


    Terms & ConditionsAccessibility statement