Workflows updates
Hello,
I wanted to know if there is functionality for the following:
I have two sheets, #1 Master and #2 Calendar. I have set up an automatic workflow: when a tick box on sheet #1 Master is ticked, a row is copied to sheet #2 Calendar.
I then realised that if I needed to update anything on #1 (after the row was copied over), the amendments were not being carried over to #2. I tried other workflows but only succeeded in creating a duplicate row on sheet #2.
Is there anything I can do to correct this? Perhaps a workflow or function that removes duplicates with the same row identifier?
Thanks😃
Answers
-
How many columns do you have on your sheet? I am thinking maybe you can use DataMesh if you have access to it so it will evaluate and run every set time to check and update the columns according to the identifier.
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Hi @Itai
I don't think we do have access to DataMesh. Is there another way?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives