Share sheet as a copy - Consolidation
Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators.
The idea is :
- I build a main spreadsheet, and I want multiple collaborators to fill this sheet individually
- I want to keep track of all the status of certain indicators for each collaborators
- I then would like to consolidate the data into my main spreadsheet (basically a sum of values)
I did find success using a workspace and manually create a new sheet from a template for my collaborators, then consolidate the data thanks to a Report.
However, if I change my template, I have no way to automate the create new / share sheets part of the process. Any idea on this?
Thank you and please let me know if this is not clear (French here!).