Question on creating template tools that automatically feed and update rows to a central repository
Our department was recently running into the issue of housing data and tools in consistent manner that allows for accurate department wide reporting without the need for additional administrative activities and duties to keep it up to date
As part of this I was trying to figure out a way to accomplish the two items below through Smartsheet.
Build template tools that would be copied and used for one specific project. These would have automation prebuilt in that can automatically feeds any new entries made to the copy of this tool into a collective repository sheet. This would also need to allow for the updating of these repository rows if changes are made in the project specific copy (does not create an entirely new entry in the repository each time a change is made to a template row as this will lead to duplicate entries).
Current Solution to Problem 1
My current attempt to solve problem one was creating template with an automation workflow that says
If row or column changes----->Copy Row to Master Repository
The problem with this per the below image is that this creates duplicate entries in the repository for the same entry. The goal would be to have these upload the row to the repository as soon as information is entered to the template, and then update that single row in the repository as updates are made to the single row on the template.
Set a template up so that copies made of the template can only be saved/copied to a specific folder/workspace location. The hope for this would be to avoid having the different projects copies for these tools spread all over Smartsheet and instead they would always be collected in the same folder/workspace.
Solution to Problem 2
At this time I have not found any solutions that address the issue for problem 2
Thanks for any assistance that can be provided!