Copy a specific field in sheet 1 to a specific field in sheet 2

I have 2 SmartSheets - 1. My Project Plan and 2. My Communications Plan

I would like to copy specific fields from one sheet to another. For example, on my Project Plan I have a "Start Date" on row 177 that I would like to copy to "Admin Date" on row 1 of my Communication Plan.

The Project Plan dates change periodically and I'd like the Communications Plan to reflect the most recent information without having to manually populate it every time there is a change.

I played with vlookup, index, and match, but can't seem to get anything to work.

Any suggestions?

Find more posts tagged with

Formulas

Accepted answers

All comments

MelM18

This was answered in another post

The best method is a direct cell link.

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.