automate RYG balls
I'm a smartsheet newbie and i'm ultimately trying to build a formula that automates task progress based on the following:
If % Complete = 100, return Blue
If it’s not scheduled to start yet, return Clear
If it’s past the scheduled finish date, return Red
If % complete >= (today date-start date)/task duration, return Green
Otherwise, return Yellow.
After researching if statements i wanted to at least start with the first simple if statement to return blue ball if task is 100% complete. Below is what i used for the formula but nothing returns in the cell.
=IF([% complete]1 = 100, "Blue")
Help Article Resources
Check out the Formula Handbook template!