Hello,
I'm relatively new to Smartsheet and found the following formula on this discussion board (I can't find original post). I need to update this formula to show "green" for tasks that are not scheduled to start yet, rather than blank.
The columns in play are Planned Start Date, Planned End Date and % Complete
- If task has NOT reached its Start Date and % Complete = 0, green health ball
- If task has reached its Start Date or not reached its End Date and % Complete > 0, green health ball
- If % Complete = 1, blue health ball
- If task has reached or passed its Start Date and % Complete = 0, yellow health ball
- If task has passed its End Date and % Complete < 1, red health ball
Here is the current formula that I need to modify for bullet 1 above:
=IF([% Complete]@row = 1, "Blue", IF([Planned End Date]@row < TODAY(), "Red", IF([Planned Start Date]@row < TODAY(), IF([% Complete]@row = 0, "Yellow", "Green"), IF([% Complete]@row > 0, "Green"))))
