How to I change the Schedule Heath formula on the Project Plan from the PMO Template Set?

Hello, I am using the PMO Template Set from Smartsheet and am having trouble figuring out how to write a formula to change the Schedule Heath column to capture the following:

If the Status is flipped to "Complete" =Green.

If today is 5 days or fewer from the start date and until the end date OR the Status is flipped to "Complete" = Yellow.

If today is the day after the end and until status is flipped to "Complete" = Red.

If tried to use a few of the other functions that appear to be similar to my situation on this forum but....still can't get it to work.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!