How do I reference one cell to the left?

In Excel I use this formula =INDIRECT("RC[-1]",0)+1 to create a row that could look like 23, 24, 25, 26, etc... for example, but this formula does not work in Smartsheet. I cannot use an absolute reference because I need the value for each cell to be one greater than the cell to the left, instead of one greater than the initial cell referenced. Is there a way to reference a cell by position in this way?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

If you manually enter the first number into the first cell, you can enter this into the second cell

=[First Column]@row + 1

and then dragfill across the row.

Schmic52

This just added 1 to the value in [First Column]@row.

I checked Create a Cell or Column Reference in a Formula but I could not find the solution.

Any further suggestions?

Paul Newcome

@Schmic52 Are you able to provide screenshots for reference to what you are wanting to accomplish? It sounds like the above solution worked as it was supposed to work (adding 1 to the value), but it sounds like you are wanting something different.

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.