Formula for RYG for Project Schedule Status
We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in a YELLOW state so a return to green plan can be worked on.
So what I'm looking for is a formula that can look at a projects critical path and then if "At Risk" tasks are slipping turn the project status to YELLOW.
Answers
-
@rcbacon , you didn't elaborate on the formulas you used for red or green, but you should be able to nest IF statements to use the formula for green, and red, then let yellow be the final false default. Just be careful with nesting IF statements, so you don't conflict the results and get an error.
If you don't mind to share the criteria you're using to set status, and your red and green formulas, that would help to provide additional direction.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!