Is there a way to identify if a column has duplicate numbers

Roshni Verappan

Hi

I have a Smartsheet that has a column for File # which are unique and shouldn't be any duplicates, is there a way to identify if a column has duplicate numbers and set a conditional format or some indicator?

Thank you  

Don Wilcox

Hi Roshni,

I'd try this.....

Create a helper column that is a checkbox. Then add this formula:

=IF(COUNTIF([File #]:[File #], [File #]@row) > 1, 1)

or check out https://community.smartsheet.com/discussion/72866/formula-to-remove-duplicates-in-a-column. The answer uses a helper column and a date create (system) helper column.

Hope this helps.

Don Wilcox

drwilcox.57@gmail.com

Don Wilcox

Hi Roshni,

I'd try this.....

Create a helper column that is a checkbox. Then add this formula:

=IF(COUNTIF([File #]:[File #], [File #]@row) > 1, 1)

or check out https://community.smartsheet.com/discussion/72866/formula-to-remove-duplicates-in-a-column. The answer uses a helper column and a date create (system) helper column.

Hope this helps.

Don Wilcox

drwilcox.57@gmail.com

Roshni Verappan

Hi Don

Thanks vey much this worked great and then I ran a report to filter out what is not needed.

Appreciate this community, always so helpful.

Cheers

Roshni