Is there a way to have a cumulative formula?

Tvl_97
Tvl_97 ✭✭
edited 05/12/22 in Formulas and Functions

Hey everyone,

I would like to know if there's a formula that calculates the cumulative time because I have to drag it down everytime.

I have 3 columns:

1) Task

2) Task Duration

3)Cumulative time

I know that for row 2, I can just do [Task Duration]@row + [Task Duration]1, but I can't do that for row 1.

Also, by using this method, if I remove a row in the middle (i.e. row 10), everything else after it will be #BLOCKED because the reference got deleted.

Is there another method of doing it?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!