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.
Process automation with cell linking ?
We have developed a master process sheet that starts when a client signs a design contract and is completed when the build project is completed. It is rather long at about 250 tasks! and take between 6-12 to complete. We serve approximately 20 clients at a time in various stages. We are operating each client out a copied master process sheet. This is working fine, but we will need to modify our process for more efficiency at some point in the future.
I just realized that I could cell link this entire master process sheet into a template sheet, and with each new client, they are now working off of a linked master. I would be able to update all sheets at once for any changes. Does any one else do this? If not, how do you handle this scenario.
I am am envisioning a cell link coming into a sheet, along with the name of the "role" of who is responsible for completing the task, and then the assigned to column auto filling with a name of the employee who is assigned that role. Maybe I am overthinking this, but wow would that make my life easier!
Thank you you very much for any advice! I am so glad this community is up and running!