Auto- fill information from another smartsheet

How can I make my smartsheet pull columns of information from another sheet? The data I want to have duplicated is entered first on a vendor intake sheet, the two columns I want to 'link' or duplicate are a unique name and contract number (in separate columns) and I want to have them pre-populate on a contract deliverables sheet in respective columns.

I tried to reference, and it did not work. Linking did work but I cannot like that amount of cells and want it to be automatic. I tried the INDEX/MATCH… no luck. Please help.

Find more posts tagged with

Formulas

Cell linking

References

Accepted answers

All comments

Mark.poole

do you have any unique identifiers on the receiving sheet? Index match, or index collect would work if you have something on the sheet to match the information to. You could also use automation to copy the whole rows over, how ever I don’t believe that would be feasible in this situation.

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.