Flag based on % completion relative to end date

Hi guys,

I'm trying to create a formula that flags, Green, Yellow, Red, when a specific % is closer to the end date. For example, if I have 95% and end date is 10 days ahead, flag should be green, however, if I have 25% completion and I am in 10 days of reaching the end date, it should be red.

I was thinking of also, having a date variance, such as end date - today = X, then using this X with the % completed flag.

Any ideas on how to approach this?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!