Check 2 Columns for duplicate values and Combine into Parent Child

I have a sheet where we capture name and e-mail. I want to check the sheet to see of these match and if they do, combine the duplicates into a parent child relationship with the first entry being the parent. I already capture the creation information so establishing the first entry should not be a problem.

Any suggestions?

Answers

  • David Joyeuse
    David Joyeuse ✭✭✭✭✭

    As far as I know, there's no way to automatically combine rows in a parent/child hierarchy.

    Now, if you want to do this so you only display each name/address once, I can suggest you a workaround to this.

    Add an helper column named "Duplicate" (flag type column) with this formula:

    =IF(COUNTIF([Name]$1:[Name]@row,[Name]@row,[EMail]$1:[EMail]@row,[Email]@row)>1,1,0)

    This will check if the name/email address combo was previously entered.

    Then create a report out of this that only show rows where duplicate is at 0.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!