Auto Cell Linking With Templates

centorbi_cabinetry

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. 

Shaine Greenwood

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/