I want to make my RYGG ball gray if the Start Date field is empty (currently showing up as Red).

Julie Kron

Here is the current formula. I've spent too much time trying different ways, can someone out there help me? =IF([% Complete]@row = 1, "Gray", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row < TODAY() + 7, "Yellow", "Green")))

Thank you!

Andrée Starå

Hi @Julie Kron

I hope you're well and safe!

Try something like this.

=IF([% Complete]@row = 1, "Gray", IF([Start Date]@row ="","",IF([End Date]@row < TODAY(), "Red", IF([End Date]@row < TODAY() + 7, "Yellow", "Green")

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

Andrée Starå

Hi @Julie Kron

I hope you're well and safe!

Try something like this.

=IF([% Complete]@row = 1, "Gray", IF([Start Date]@row ="","",IF([End Date]@row < TODAY(), "Red", IF([End Date]@row < TODAY() + 7, "Yellow", "Green")

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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