Identify row number

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

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.