Has anyone developed a "heath status" equation that considers baseline and task weight?
Hello, has anyone developed an equation for a "health status" (red, yellow, green balls) that considers both the task status in comparison to the planned start/end dates as well as the weight of that task duration?
I tried playing around with the following logic:
Green: the task is not late and the actual % complete of the tasks is greater than or equal to 90% of the planned (aka baselined) % complete.
Yellow: the task is not late and the actual % complete of the tasks is greater than or equal to 75% of the planned (aka baselined) % complete.
This does not really work though, because the difference between a green and yellow status for a task is 3.5% variation between Actual % Complete and Planned % Complete (and my team typically tracks Actual % Complete in 5% increments because no one is going to say a a tasks is 13.5% complete!). Curious if anyone has a create way to showing "Health Status" in relationship to the baseline.
Thanks!
Answers
-
Hello @jto32423 ,
Try using the Averaged RYG for IF and COUNTIF formula for the symbols using one of the following logical expressions - (I have selected the one in blue outline for you)
To do this, add a manual column for symbols with Green, Red, Yellow buttons and the to the next column add the formula to test your logic. Hope this helps. Let me know. :))
Cheers!!
Ipshita Mukherjee
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!