Highlighting Duplicates

Lakshman .

Hi Guys,

I read some previous articles in community to highlight duplicates but it did not work for me. I am trying to highlight duplicated submitted in the building number column. can some one pl help me.

Paul Newcome

Try something along the lines of this in a checkbox column...

=IF(COUNTIFS([Building Number]:[Building Number], [Building Number]@row) > 1, 1)

Paul Newcome

Try something along the lines of this in a checkbox column...

=IF(COUNTIFS([Building Number]:[Building Number], [Building Number]@row) > 1, 1)

Lakshman .

tried with this article but not worked for me

https://community.smartsheet.com/discussion/1827/duplicate-values-conditional-formatting

Paul Newcome

What exactly do you mean by "not working"? Is it producing an error or are you getting an unexpected result, or...?

Andrée Starå

Hi @Lakshman .

First, we will need to add a so-called helper column, as described above. Then you’ll need to add the conditional formatting rule and base that on the helper column.

Make sense?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lakshman .

i tried in a regular column it did not work..I got it later, i did add the check box column now i can see check mark in duplicate entries of the rows... cheers thanks.. have a great weekend

Paul Newcome

Happy to help! 👍️

Andrée Starå

@Lakshman .

Excellent!

Happy to help!

CristianTwork

Hello,

I am not sure if my issue would be the same.

Our reps submit a form online. When it is submitted to the smartsheet I would like it to be flagged if 2 conditions are met. If Order Number and ID has been previously submitted on a previous row

I tried a formula similar to the one mentioned above

=IF(COUNTIFS([Order Number]:[Cus ID] @row) > 1, 1)

but i am getting an #unparseable error, I am not sure if this is even the formula I am looking for.

Any help would be greatly appreciates

Paul Newcome

@CristianTwork You would want a formula something along the lines of...

=IF(COUNTIFS([Order Number]:[Order Number], [Order Number]@row, [Cus ID]:[Cus ID], [Cus ID]@row) > 1, 1)

Peter3112

Is there are way to apply this method to new rows? i.e. formulas are automatically entered into the duplicate checker column

Andrée Starå

Hi @Peter3112

I hope you're well and safe!

Yes, you'd use the column formula feature.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

Elsa A

@Paul Newcome

Have tried this formula and are receiving the error "INCORRECT ARGUMENT SET"

IF(COUNTIFS([Building Number]:[Building Number], [Building Number]@row) > 1, 1)

What am I doing wrong? See below. Need to flag when there are duplicate stores like example: 1871

Tamara Gordon Berlik

@Elsa A

Your formula should be =IF(COUNTIFS(Store:Store, Store@row)>1,1)

just needed to close the store argument before the greater than symbol

have a great day

Paul Newcome

@Elsa A Yes. You just have a misplaced parenthesis. @Tamara Gordon has provided the correction above.

Elsa A

@Tamara Gordon and @Paul Newcome ,

Success! Thanks community! :)