Detecting Duplicates in a Column

Donna T
Donna T ✭✭
edited 02/12/21 in Formulas and Functions

I know there is a recent post that speaks to detecting duplicates in two sheets. I'm not quite understanding; there seems to be a disconnect for me, forgive me for asking the same question again. :)

Sheet A has the TNumber of students granted funds - {Granted}

Sheet B has the original student request for funds. {SpringTerm}

I want to create a column where a checkmark on {SpringTerm) if the TNumber appears on the {Granted} sheet and/or if it appears more than once on the {SpringTerm} sheet.

Ultimately, we don't want to pay them twice {granted} and we don't want to process a duplicate request {SpringTerm}

In the end, I want to be able to automate sending a report that eliminates duplicates.

Thank you,


{SpringTerm} Sheet:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!