Linking another Sheet

Hi All,

I am having some challenges which I was hoping someone might be able to help me with… There is an existing Smartsheet that a project team uses to display new product introductions. As this sheet is updated in real time and I am not in that team, I can't add fields that I want to track into that sheet; however, some of the fields are useful for me to use.

In light of this, I have created a separate tracker, where I can track my own work and department specific activities, whilst at the same time trying to include data I need from the other sheet, which as it's updated in real time and existing data can change, I would like to make a direct link with. What I am finding however is that

When new line items are added to the 'original' sheet, I can't see them in mine without manually going in and getting them or checking this everyday
I have to create an individual link to every cell in my sheet to the original. I am dealing with thousands of lines of data, so it's taken me forever to do this.
The 'Paste Special' function also greys out the ability to link to the source sheet, even though I am an editor in that sheet, so simply just 'copy and pasting' doesn't seem to work...

What I want to know is:

Is there a simple way I can have my sheet auto update when new data is added to the source sheet and link all the relevant cells without having to manually go in an link everything cell by cell…

I am really struggling with this and finding it hard to track all the data I need. I am concerned I will miss something 😫

Find more posts tagged with

Sheets

functionality

Automations

Cell linking

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/143688/linking-another-sheet

Hi,

I hope you're well and safe!

1️⃣ 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.

2️⃣ Column Links in Table View

Would any of those options work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with 💡 ⬆️ ❤️ and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Luke T

Hi Andree, I have tired using the VLOOKUP or Index function, but it just usually yields an error. It also doesn't solve the challenge I have if there are new additions to the sheet it will automatically pull the data in. Thanks!

Andrée Starå

Happy to help!

You must have something to match it against.

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 need in the Destination sheet.

Does that make sense?

✅ Remember! Did I help answer your questions or solve the problem? Please support with 💡 ⬆️ ❤️ and/or ✅ Answer. It will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

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.