Change Symbol based on date / clear if blank

Jerry Alexander

I'm wanting the symbol to change based on the date field.

If date is today (or in the past), Red

If date is tomorrow, turn Yellow

If date is past tomorrow (in the future), Green

If date is blank, Blank - No color/Symbol

This was working to some degree, and somehow I broke it.... :)

=IF([Scheduled End Date]@row <= TODAY(), "Red", IF([Scheduled End Date]@row <= TODAY(1), "Yellow", IF([Scheduled End Date]@row <> "", "Green")))

Jerry Alexander

Fantastic! you're a genius! Thank you

Andrée Starå

Hi @Jerry Alexander

I hope you're well and safe!

Try something like this.

=IF([Scheduled End Date]@row = "", "", IF([Scheduled End Date]@row <= TODAY(), "Red", IF([Scheduled End Date]@row = TODAY(1), "Yellow", "Green")))

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jerry Alexander

Fantastic! you're a genius! Thank you

Andrée Starå

@Jerry Alexander

Excellent!

Happy to help, and thanks for the kind word!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!