0

I have a field 'Renew By' which I want to change the background colour if the 'Renew By' date is after Today().

How do I achieve this as a formula

Green if before and red if after Today()

1 reply

null
    • Nick
    • 3 yrs ago
    • Reported - view

    Create a formula field with this code:

    ---

    styled(text('Renew By'), if 'Renew By' <= today() then
    "green"
    else
    "red"
    end, "")

    ---

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 575Views