Copy row from source sheet to destination sheet but continue to update source row

Cristian ✭✭✭✭
edited 03/14/24 in Smartsheet Basics


How do you copy a row from a source sheet to a destination sheet and continue to update source row while reflecting changes on destination sheet.

Additional info. We have two sheets, Sheet A (source) and Sheet B (destination). In essence both act as source sheets.

When a new row is checked marked in Sheet A, I have a workflow that moves over the row to Sheet B. This works fine.

What I am trying to do is add rows in Sheet B and copy them over to Sheet A. In Sheet B we are always updating rows and I need the information reflected in Sheet A.

I tried a workflow in Sheet B, and that works fine, it duplicates my rows when updates are performed in Sheet B.

Any info would be helpful.

(Sorry, can't provide screenshots)