Formulas -Automated at risk status

Zacharias Vailakis

Hi all,

I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist.

Red: % Done is equal to 0% and the Start Date has passed

Yellow: % Done is bigger than 1%

Green: % Done is 100%

the formula I'm coming is this: =IF([% Done]1 > 1%, "Yellow", IF(AND([% Done]1 = 0%, [Start Date]1 < TODAY(), "Red", IF([% Done]1 = 100%, "Green"))

but I cannot make it work...any ideas??

Paul Newcome

Percentages in formulas are referenced as part of a whole or part of one. So 100% = 1, 50% = 0.5, 25% = 0.25, so on and so forth.

Try something like this...

=IF([% Done]@row = 1, "Green", IF([% Done]@row > 0, "Yellow", IF([Start Date]@row < TODAY(), "Red")))

Paul Newcome

Percentages in formulas are referenced as part of a whole or part of one. So 100% = 1, 50% = 0.5, 25% = 0.25, so on and so forth.

Try something like this...

=IF([% Done]@row = 1, "Green", IF([% Done]@row > 0, "Yellow", IF([Start Date]@row < TODAY(), "Red")))

Zacharias Vailakis

thanks a lot! that resolved all the issues, and works like a charm!

Paul Newcome

Happy to help. 👍️