Formula for Milestone Health

I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the end there is a column "Site Health" which I think is the average of all milestones health .

I appreciate very much if someone can help me!

Thank you very much!😉


Thank you very much for any help!😉



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!