Functions and Formulas


I am trying to write formula to calculate difference in BASELINE END DATE to actual END DATE

=[Baseline End]58 - [End Date]58.

Now I want to compensate for RAIN DAYS but receive UNPARSEABLE

=[Baseline End]58 - [End Date]58+(duration)4

Where I missing it?

Thanks, Gary


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!