Variance formula

Yaya ✭✭
edited 10/18/22 in Formulas and Functions


I'd like to create a formula for caculating variance between baseline date and finish date. The baseline function doesn't really work well in SS.

The logic is if there are no dates in the Baseline finish column, then keep the variance cell empty.

If there are dates in the Baseline column, then calculate the networking days between Baseline finish date and actual finish date. If actual finish date is delayed than the baseline finish date, then I'd like it to show Minus -.

Much appreciate your help!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!