Syncing data between sheets
I don't have access data shuttle. I have an automation to copy information from one master sheet to another. I need the information from sheet #1, when various cells are updated, to sync information to sheet #2 without "copying" or "moving" rows. thank you for your help in advance.
Answers
-
@noshiro If you don't have Data Shuttle Access then I assume you don't have DataMesh either?
Other than using those or the API it's not something you can do in Smartsheet core. We do have another option as well that was developed to be a solution to this and can keep multiple sheets in sync with a master sheet based on a condition in the master too.
Here it is:
Darren Mullen - Looking to take your Smartsheet knowledge to the next level and become an expert? Join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen Thank you for your response. My company does not want to use add-ons, so I am trying to figure out a way to work with the basics that we have.
-
@noshiro I'm curious what the resistance is to using additional tools whether it's a premium app from Smartsheet like DataShuttle or a 3rd party?
Darren Mullen - Looking to take your Smartsheet knowledge to the next level and become an expert? Join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen Its the additional cost.
-
@noshiro Ok. Depending on what you are looking for cost may not be as much as you think, especially for a 3rd party soluion.
Darren Mullen - Looking to take your Smartsheet knowledge to the next level and become an expert? Join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen Thank you! I'm not the person who can make that decision, but will keep it in mind should they inquire for suggestions. Thank you for the suggestion. have a great day
