How do I remove duplicate rows if there is a duplicate in column 1?

My data has unique Job IDs but every time a row is updated in my master sheet it is moving it into another sheet creating duplicates. I want to delete the older rows and just keep the newly added row. How do I do this? Please help.

Answers

  • Jess A
    Jess A
    edited 11/26/24

    @Michelle Choate 2

    Any idea how to do this one?

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 11/26/24

    Hey @Jess A

    One way is to add a helper column to your master sheet that looks to see if the unique ID already exists on your other sheet. You can then set your automation to run only when the helper column indicates the ID is a new ID. (Do you want the Move Row to happen when all master sheet updates are completed?)

    Create a helper checkbox column on your master sheet. As with most helper columns, you can sling this column to the far right and hide it if desired.

    =IF(your unique ID master sheet]@row<>"", COUNTIFS({source sheet Unique ID column},[your unique ID master sheet]@row)=0,1)

    Add a condition to your automation to only move rows when the box is checked.

    Will this work for you?
    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!