How i can build automation based on data change trigger
Hello
I would like to build Row Copy automation when one of the fields is changed from blank to any value in a specific row, but I don't want to copy the row again when the value changed again in the same cell
how can I avoid the copy of the row twice?
Best Answer
-
Hi Dezi, create a helper column called "Row Copied". In your automation to copy the row, after your row copy action, add an action to Change a cell value and set it to the Row Copied column. Enter some value like "Copied". Then modify the same automation to conditionally filter any rows where Column Row Copied is not blank.
Does that help?
Answers
-
Hi Dezi, create a helper column called "Row Copied". In your automation to copy the row, after your row copy action, add an action to Change a cell value and set it to the Row Copied column. Enter some value like "Copied". Then modify the same automation to conditionally filter any rows where Column Row Copied is not blank.
Does that help?
-
Hello Ryan
Thanks i will try
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives