Overwrite rows if duplicate
Is there a way to override rows on my sheet if there is a duplicate row ID on that sheet?
Example: on sheet 1 when a certain column is filled out it triggers that row to copy to sheet 2, however this trigger row can be changed, and every time someone changes it, it copies the row again to sheet 2 with the changes. Is there any way that if the same row ID is already on sheet 2, can the row with the new changes on sheet 1 that is moving to sheet 2 just override the row in sheet 2 with the change?
Help Article Resources
Check out the Formula Handbook template!