Automate Linked Cells
I have an issue that I've seen in other discussions but I have not been able to figure it out for my situation. I want to automate the process of linking cells from one smartsheet to others. I will provide as much information as possible below.
- We have a master sheet, "Project Dashboard" with about 15 columns where I want the linked cells to be. When we enter a new project, we create a new row and add the project name in the first column.
- Then we link the cell in the next column from a different sheet, the "Project Plan". Each project has a unique "Project Plan" sheet. Everything we link are dates.
- This brings me back to the master sheet, now with a linked date in the next column.
- I repeat this process for all 15 columns. This was not an issue when we had 5-10 projects, but we are now approaching 20+ and many need to be entered right away, consuming a lot of time.
- The cells I want to link are always in the same spot for all projects, the project plans are all identical just with different dates.
How can I go about this?
Answers
-
Hello @steven.saporito - This is a function of the Control Center add-on. You create a blank project blueprint of all of the sheets and their relevant links. Then when you add a new project to your master sheet, Control Center stands up a new project and all of the links are automatically inserted.
-
Thank you for the quick answer! I will try this out tomorrow at work and come back if I have any trouble.
-
Is there a way without this feature? I didn't realize this was an add on.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives