Delta/Slippage Formula

edited 12/09/19 in Formulas and Functions

I can't seem to get the right formula together in my Active Projects Master Schedule to show the Delta/Slippage in the construction schedules.

I have individual columns for Original Finish (Date), Current Projected Finish (Date), and Change Order (CO) Days that are populating dates and numbers with cell linking from the individual project schedule sheets.

I know the formula for the Delta/Slippage needs to be: Original Finish + Current Projected Finish - Change Order (CO) Days = Delta/Slippage

Any ideas on how the formula should be put together in Smartsheet?  All my attempts end in error messages.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!