Highlighting Duplicates
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.
Best Answer
-
Try something along the lines of this in a checkbox column...
=IF(COUNTIFS([Building Number]:[Building Number], [Building Number]@row) > 1, 1)
Answers
-
Try something along the lines of this in a checkbox column...
=IF(COUNTIFS([Building Number]:[Building Number], [Building Number]@row) > 1, 1)
-
tried with this article but not worked for me
-
What exactly do you mean by "not working"? Is it producing an error or are you getting an unexpected result, or...?
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
Happy to help! 👍️
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
@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)
-
Is there are way to apply this method to new rows? i.e. formulas are automatically entered into the duplicate checker column
-
Hi @Peter3112
I hope you're well and safe!
Yes, you'd use the column formula feature.
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
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
-
@Elsa A Yes. You just have a misplaced parenthesis. @Tamara Gordon has provided the correction above.
-
@Tamara Gordon and @Paul Newcome ,
Success! Thanks community! :)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives