Identifying Duplicates in a column

Heather Campbell

Hi,

I am trying to identity duplicates in a column on a smart sheet but I don't think I am doing to formula correct. I did add a flag column and tried to enter the formula in there but its not working.

I want to identify if there are any duplicate entries in the UNIT# column.

Thank You,

Andrée Starå

Hi @Heather Campbell

I hope you're well and safe!

Try something like this.

=IF([Unit#]@row = ""; ""; IF(COUNTIF([Unit#]:[Unit#]; [Unit#]@row) > 1; 1)

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Heather Campbell

Thank you for responding. I am still having problems I wonder if I am not doing to the row part correct. Do I put the row where the numbers start do 2 or 1 where the formula is?

I'm sorry I am super new to this and have no idea what I am doing.

Andrée Starå

@Heather Campbell

Happy to help!

You have to exchange the 2's to @row instead.