Color Ball Change Formula Help
Hello Smartsheets Community:
I am needing some help completing a formula that I have written for the color balls to change based on Start and End Dates along with % Complete.
What I would like to happen is when a new project plan template is open and all our % completes are set to 0% that the color ball be gray. Based on the screen shot of the formula below, I have that working correctly.
Then as people mark the % complete with a % the color ball turns green. Again, based on the formula below, that works as well.
Last, when a task is marked 100% I want the color ball to go back to Gray - this is where I am having the issue. As you can see below, I have tow tasks marked 100%, but its returning a green ball. Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!