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()

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Nick
    • Nick
    • 2 yrs ago
    • Reported - view

    Create a formula field with this code:

    ---

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

    ---

    Like
Like Follow
  • 2 yrs agoLast active
  • 1Replies
  • 568Views