Once 'complete' can I move an entire row to another created sheet

Once a line item (row) is marked YES complete, can that entire row (with or without formatting) be moved to another sheet so that it is not shown on the in-progress/working sheet?

Or... can I move an entire row within the sheet if a specific column is marked such as conditional formatting.

Thanks

Find more posts tagged with

Sheets

IT & Operations

Conditional Formatting

Cell linking

Comments

J. Craig Williams

Amye,

This can be done using third party tools like Azuuqa and Zapier.

I use Zapier for this use case.

I doubt either works on formatting, but have not tried it yet.

Craig

CherieMac

Not automatically. We set up an alert to be sent when the row is marked COMPLETE on our OPEN sheet and have one person designated to move the row to the CLOSED sheet.