Running total in worksheet

Jennifer E
Jennifer E ✭✭
edited 12/09/19 in Smartsheet Basics

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!