Baselines & Variance If Formula


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


Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    edited 05/14/24 Answer ✓

    Looks like a couple extra brackets.

    =IF([Variance]@row = 0, "On Track", IF([Variance]@row < 0, "Behind Schedule", IF([Variance]@row > 0, "Ahead"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!