Identify row number

Fadi Odeh

Hi,

I need to calculate the cumulative of expenses in my sheet, I used the below formula:

=SUM($[Expenses]$1:[expenses]@row)

However when I sort the sheet, and row 1 for example become row 12, the formula will update itself to:

=SUM($[Expenses]$12:[expenses]@row)

Is there a way to fix this so the formula is not affected by sorting

Thanks

Fadi

Mike Wilday

Have you considered using the sheet summary data?

https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary

Using Sheet summary will keep your roll-up data from getting resorted into the main data. And you can use that sheet summary data to capture all different kinds of information from your main sheet.