Is there a way to change the colour in a field based on the value in the field?
For example, I have a list of projects with a Due Date. I’d like the Due Date (or background of the field) to turn red if past due.
Any suggestions?
Hi Mike,
There’s a setting on Number fields to display the value red if it’s negative. But not for Date fields that are past due.
But you could use a Script field to return an Emoji character that’s red along with some text perhaps such as “OVERDUE ‼️”
-
This reply was modified 1 year, 6 months ago by Brendan.