Move Row to New Sheet

eshortri

I'm trying to figure out how to move a row that contains "New Trip Report" when a new row is added containing "Corrected trip report" and the Report ID's match.

For example: see screen shot. Adding row 2 containing Report ID TR00001TX115 would trigger moving row 1 to a new sheet.

If anyone knows how to do this, please let me know.

Paul Newcome

The search function for automations can be a bit of a pain. My usual "go to" method is to "Rename" my target sheet so that I can copy the name of it exactly as it is (then cancel the rename) and paste it into the search bar. I have also seen it take some time for the search feature to pick up newly created sheets even after refreshing your broswer.

Bcupp24

You simply need a trigger to build the automation around. Simply put, when the new row is added as corrected you could have a flag to check to move the old row to a new sheet.

eshortri

@Bcupp24, I'm having trouble being able to select another sheet to move the rows to. Every time I try, nothing comes up. See Screen shots.

Paul Newcome

The search function for automations can be a bit of a pain. My usual "go to" method is to "Rename" my target sheet so that I can copy the name of it exactly as it is (then cancel the rename) and paste it into the search bar. I have also seen it take some time for the search feature to pick up newly created sheets even after refreshing your broswer.

eshortri

I was able to get it to assign a sheet. Also adding a helper column to easily identify rows to be moved got me the result I was looking for. Thank you.

Paul Newcome

Happy to help. 👍️

Bcupp24

Sorry I just now bounced back to this one. I see Paul got you covered and you also go the concept down.