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/
