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.


  • Malaina Hudson
    Malaina Hudson ✭✭✭✭✭
    edited 03/05/21

    @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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!