Workflow to Sync Rows between sheets

SarahML

I have 2 to-do lists with teams that I work with and I am trying to to simplify adding and updating my tasks to just one list.

I've created a workflow to copy rows from one sheet to another but instead of creating a new row in the destination sheet as I update the information I would like for the row to be updated in the destination sheet. Is there a way to do that? Currently I can only figure out how to copy and move a row.

Thanks!

Andrée Starå

Hi @Sarah Lanahan ahan

You could maybe use cross-sheet formulas and VLOOKUP or INDEX/MATCH instead.

Is there something unique that could be used to connect the sheets/rows?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!