Formulas -Automated at risk status
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??
Best Answer
-
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")))
Answers
-
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")))
-
thanks a lot! that resolved all the issues, and works like a charm!
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!