Formula help on RYG Balls for Baseline Variance

hello all

I'm struggling with this because the variance is in Days. I did a basic IF statement where:

if the Status = complete then Green,

and "nested if" if the Variance was < -5 then Red else Yellow.

It just turned complete things Green and everything else yellow, because the variance is in Days (eg. 1d or -2d not a read number)

Ultimate Goal is to put the health of the project on a report then Dashboard for Executive lead team. Schedule Variance is my first thought.

Thanks for any guidance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!