Find Duplicates in Range Then Report Another Column

Options

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?

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Dear @andihawes08

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

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ 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
    Options

    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!