Formula to automate the symbols on a sheet.
The Task Progress column is linked to the % Complete column.
when someone inputs a value of 100% in the % complete column, the task progress changes to a Green dot, and the same goes for when the % complete is 0% - Red dot, 1-99% - Yellow dot.
I would like to add a gray dot in the mixture so I need a new formula to reflect the following:
Task progress dots definition
Red Dot = When the task is past the original finish date, The red dot should auto-populate on the task progress column and the Status column should have 'At Risk' text (not sure if the latter can be done?). The % complete column will remain empty.
Please let me know if this can be done?
Current Column formula for Task Progress Column -
=IF(ISBLANK([% Complete]@row), " ", IF([% Complete]@row = 1, "Green", IF([% Complete]@row = 0, "Red", IF([% Complete]@row < 1, "Yellow"))))
Current Column formula for Status Column -
=IF(NOT(ISBLANK([% Complete]@row)), IF([% Complete]@row >= 1, "Complete", IF([% Complete]@row > 0, "In Progress", "Not Started")))
Help Article Resources
Check out the Formula Handbook template!