Reference the value in the row above and change this cell value as a result

In excel I would use the formula:
IF(A2=A1, C1+1,1)

What this allows me to do is say, if the value in column A on this row matches the value above it, then increment the value in this cell, if not start again at 1.

When you create a formula like this in excel you can fill it down and therefore have every row reference the row above.

Is there anyway to achieve that in smartsheet?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

That would work exactly the same way in Smartsheet.

nicCFA

HI Paul,

How would it work in smartsheet? Smartsheet wont accept it as a column formula, so I would need to manually add it to each cell?

Thanks

Nic

Paul Newcome

As long as you have the formula in two rows immediately above and/or below the newly added row, Smartsheet's auto-fill feature should pick it up even if it is not set as a column formula. However… It will not adjust the row numbers automatically.

To apply it as a column formula, you need to add two helper columns. An auto-number column (called "Auto" in this example), and a text/number column (called "Row" in this example) containing this column formula:

=MATCH(Auto@row, Auto:Auto, 0)

From there, we have a few different ways it could go. Are you able to provide a screenshots with some sample data for reference?

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.