How do you have a cell in one Smartsheet repeat information to a cell in another Smartsheet?

I work with dates for campaigns a lot. I have multiple Smartsheets tracking different pieces of campaigns and the dates those pieces will launch. Is there a way for me to link the date cell in one Smartsheet to a date cell in another Smartsheet - so if I change the date in one Sheet it would change the date on the other Sheet?

I think it would be a formula to set up, but I don't understand enough about the formula to understand what to do.

Also, I'm hoping I don't have to have the same columns in the same two Smartsheets, because that's not possible. Would I need to have the same Primary Column name for the two cells to match though?

Thank you for any help! This would greatly solve a lot of my back and forth issues!

Find more posts tagged with

Accepted answers

Mark.poole

you can achieve this with cell linking. No formula required. On the sheet you want to pull the date to select the cell your wanting the date to go in. Be sure it is also a date column. Then select cell linking from the toolbar up top. From there it should be pretty simple to follow.

All comments

Mark.poole

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.