Archived 2017 Posts
Archived 2017 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto Cell Linking With Templates
I need a way to auto link a row from new sheets with a master sheet because I am constantly using a template to create new project sheets containing the same info categories on each one but it takes up to much space to have all the projects on one sheet so i opted for individual project sheets. I need to be able to add key data from project sheets onto a master sheet w/o manually linking 5 cells per sheet when there is over 100 project sheets.
Comments
-
Hello,
There currently isn't a way to automatically create cell links in your sheets. When you have a moment, please submit a Product Enhancement Request using the form under Quick links on the right of the community site for this feature.
With that in mind, there are a couple of options for workarounds you can implement:
- Try using a report that gathers this data together instead. Details on reporting in Smartsheet are available in the help center: https://help.smartsheet.com/articles/522214-creating-reports
- If you have developer resources available to you, you might be able to automate cell linking with the Smartsheet API: https://smartsheet-platform.github.io/api-docs/
