How i can build automation based on data change trigger


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

  • Ryan Sides
    Ryan Sides ✭✭✭✭✭✭
    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?

    Ryan Sides

    Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube

    Come Say Hello!