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!
Best Answer
-
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.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
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.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!