Find Duplicates in Range Then Report Another Column


Dear Forum

id like to Find Duplicates in Range Then Report Another Column.

I have 1 column which lists drawing numbers and another with task IDs. id like a column that can look at this column and report a duplicate number, then report which Task ID Row it is in?


  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Dear @andihawes08

    hope you are fine, could you supply a screen shot for your sheet so i can help you.

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • andihawes08

    Not sure how a screen shot would explain it more but here it is.

    id like CQD QA column to look at Document Name column and find that value from a column in another smartsheet, then be able ot report back if it finds it, and even better, which line it found it on and apply a n input from another column on that other smartsheet

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!