Data from a shared Sheet

Question

I have data on a "copy of construction checklist" that has been shared to me.  I am an admin to the shared copy of construction checklist.  If the owner of the sheet, cycles data off the sheet due to completion, I will also loose that data, correct?

I cannot create an automation to copy/add row from the shared copy of construction checklist because I am not an owner.

What can I do to save this data so that I can reference back when we do historical reviews?

Mike Wilday · Accepted Answer

You should, as an admin be able to add an additional automation. Set one up so that when it is complete it copies the row data to one of your own sheets. This will give you a referenceable sheet.