Running total in worksheet

Jennifer E

Hi, we have a form we use to collect any service requests which are then added to the bottom of a worksheet.

I've created a formula in the top row to count the total number of requests. But is there a way to set this up so it's continually updating as new requests are added to the bottom of the sheet?

The way I have it set up right now is to count from a range within the existing sheet, but I can't expand the range much further beyond the most recent request showing at the bottom of the sheet. So in order to get the most updated total, I will always have to adjust the range in the formula to include the most recent entry. Would like for this to be automated if possible.

Any help or suggestions would be greatly appreciated.

Thanks in advance!

Jennifer  

Roger Koon

Hi Jennifer.

If you reference a column via the manner shown below, it will apply to future rows.

=COUNTIF(Going:Going, =1)

In this case, if my checkbox column "Going" is checked, it's counted. To elaborate, using "Column:Column" tells smartsheet to reference the whole column, indefinitely.

Cheers,

Roger

 

 

Jennifer E

Great! Thanks so much!