Link a column from one sheet to another sheet.

I have a detailed sheet which I input a wide range of information useful for my usecase, but I want to make a summary sheet that only shows certain columns to a 3rd party so they can just see the information that they need.

I need new rows of information to automatically link to the summary sheet when new entries are made.

How come I can't just use the "=" followed by the cell I want then make that a column formula?

Seems complicated to just make a column copy into another sheet?

Any help would be helpful.

Many thanks,

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @JonBeaumont

I hope you're well and safe!

You could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.

To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row id on as many rows as you think you need in the Destination sheet.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

JonBeaumont

https://community.smartsheet.com/discussion/comment/369959#Comment_369959

Hi Andrea,

Thanks for this.

How would I do this exactly? I'm not that in depth with Smartsheet so I have no idea how I'd go about doing this?

Thanks,

Jon

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.