Accumulative Formula required for daily cadence?


Good Morning

Hope someone can help me. I want to keep track of the accumulative total for each spreadsheet.

For example see below - Tomorrow when i enter in Thursdays actual data of 5 - i would like:

  1. The bottom total to add up to Target total 160
  2. The Actual Column to add up to 105 (if actual number is 5 for the day)
  3. The +/1 Column to adjust itself to -55 (160-105).

The tricky part is i only want this to add up when i enter the Actual figure this can be any time of the day.

Thanks everyone for your help Chris

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!