Baselines & Variance If Formula
Options
I have created a new Health column and I'm trying to use the Variance number from the baseline to reflect the following.
0 Variance = "On Track", > 0 Variance = "Ahead", < 0 = Behind Schedule.
=IF([Variance]@row = 0, "On Track", IF([Variance]@row< 0(), "Behind Schedule", IF([Variance]@row> 0, "Ahead")))
Can someone help me correct the formula please.
Thank You
Sam
Best Answer

Looks like a couple extra brackets.
=IF([Variance]@row = 0, "On Track", IF([Variance]@row < 0, "Behind Schedule", IF([Variance]@row > 0, "Ahead"
Answers

Looks like a couple extra brackets.
=IF([Variance]@row = 0, "On Track", IF([Variance]@row < 0, "Behind Schedule", IF([Variance]@row > 0, "Ahead"

Yep…Thanks Nic !
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!