Pulling in data from 1 sheet to another isn't working with any function.

PMO Template - I want to pull in the Project Name Column from the Project Metadata sheet into my custom Attendance Sheet > Project

Name Column. I've tried VLOOKUP, INDEX MATCH, JOIN COLLECT, I've changed parenthesis to brackets. I am new to Smartsheets and can't get anything to work. I've watch videos, followed community examples and nothing works.

I hand typed the CCM since I couldn't pull the data in with a formula. If pulled in correctly, it should say Cascade County MT.

Find more posts tagged with

Accepted answers

All comments

nicksnav

Hey @ydickinson! If you are merely trying to pull the name of on cell into another cell you should be able to right click in the cell you want to bring the information into and select "Link from Cell in Other Sheet" from there you can then choose the workspace, sheet, and click on the cell you want to link to. Select "Create Link" at the bottom of the window and it should then link those two cells. If the source sheet info changes, so will your cell. Let me know if this works for you.

ydickinson

@nicksnav Thanks, that works. I can't believe it was so simple.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.