How do I setup a flag for duplicates?
Hello,
First time posting here ☺
Trying to setup a flag for when the same data is entered in a row, but it's giving me a hard time ☺
help?
Best Answers
-
@srangel Happy to help!
Sorry about that! Remove the ” ” surrounding the number 1 and it should work.
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.
-
This worked, thanks!
Answers
-
you mean something like
=if([Assigned To (Change)]@row = [Requested For]@row,1,0)
or do you have more than 2 columns you want to search for?
-
I mean if the same value for Requested For is entered more than once in the same row:
=IF([Requested For]@row=[Requested For]@row, 1, 0) is giving me a red flag for all rows, even the ones not duplicated.
thanks!
-
Hi,
Welcome to the Community and the wonderful world of Smartsheet!
Try something like this.
=IF(COUNTIF([Requested For]:[Requested For]; [Requested For]@row) > 1; "1")
The same version but with the below changes for your and others convenience.
=IF(COUNTIF([Requested For]:[Requested For], [Requested For]@row) > 1, "1")
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
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.
-
Thanks! Wonderful indeed ;-)
I am not sure, I'm getting a number instead of a red flag....
-
@srangel Happy to help!
Sorry about that! Remove the ” ” surrounding the number 1 and it should work.
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.
-
My bad!
=IF(COUNTIF([Requested For]:[Requested For], [Requested For]1) > 1, "Red")
It works, only thing is it does not work for a flag, only with a red light symbol... Any ideas why??
-
@srangel Did you get it working with the flag as well?
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.
-
@Andrée Starå This formula worked for me (thank you!) and the flags are showing for duplicate rows but it's firing "invalid" for some rows and I'm not sure why. I'm trying to find duplicates that have a match to two columns, 1) Name 2) identification number, since the same person could have multiple non-duplicative entries. Can you help solve why some of these are showing as "invalid" but many are working?
My formula currently is:
=IF(COUNTIF([Name (person who submits info)]:[Name (person who submits info)], [Name (person who submits info)]@row) > 1, AND(IF(COUNTIF([Study Number]:[Study Number], [Study Number]@row) > 1, 1)))
Thanks for your help!
Clare
-
you can try to wrap it in an iferror(formula,0)
-
Hi @cpfeifer
I hope you're well and safe!
Excellent!
Glad to hear that it was helpful!
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!
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.
-
This worked, thanks!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!