Overwrite rows if duplicate

Hi,

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!