Is there a formula that can pull data based on row # & column name?

For example, I know that on row 732 (specifically that row) in the Primary column I will need information to appear in another cell. Linking things manually is not an option given the volume of rows, so I need a formula.

Any way this can be done?

Also, the information in row 732 can be moved. So in the future the data today in row 732 may be in row 563.

I'm not entirely optimistic about this because I am aware that there is no function in Smartsheet that can ID row numbers. But I thought I'd give this a try and ask.

Thanks in advance.

Find more posts tagged with

Formulas

Accepted answers

All comments

Sameer Karkhanis

You can use formula =[Primary Column Name]732. This behaves like linking a cell. Even if you insert rows in your sheet or move this row, the formula will auto adjust the row number (Its like magic!).

Berto D

This is VERY promising. Thank you for the quick reply.

Have another need that I didn't mention previously - I have the number "732" all by itself in a cell (it's a predecessor).

I need a formula that will combine the Primary Column with the number 732 to create the formula you offer above: =[Primary Column Name]732.

Is the Join function an option to combine those elements into a functional formula?

Liz Smart

@Berto_D - I have the exact same question - did you ever figure it out?

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.