Trying to see if something like this is possible within Google Sheets.
I have 2 test sheets that are linked with
And I can have Sheet2 updated automatically when a row in sheet 1 matches a value in col C.
What I want to accomplish is update Sheet2 but have it so that if the corresponding data in sheet 1 is deleted, Sheet 2 is not affected. Is this possible?