Is there a way for a master sheet to be automatically populated by project sheets? What I mean by this is that I have them linked currently but if I were to add a row to the project sheet would it add the new row into the master sheet?
I am pretty sure that there isn't. I was looking for this a couple months back.
Hi Meg,
You can copy or move new rows automatically with a service like Zapier.
Would that work for you?
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
Hi Meg, agree with the others, not out of the box. We have automated this in the past using a custom app built with the Smartsheet API and Control Center can help out too but I expect you are looking for something less heavyweight!
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…
