Any formula, if duplicate, say: "Duplicate"?
Answers
-
Can you copy/paste the exact formula that gives you the error from the sheet to here?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Below is the one, just diferent column names
=IF(AND([Column B]@row <> "",Β COUNTIFS([All Names]:[All Names], [All Names]@row) > 1), "Duplicate"))
-
Can you pull it directly from the sheet though and post here?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
I can't do that,
sorry.
-
I mean to go in to edit the cell as if you are going to edit the formula, highlight the formula, copy it, then paste it here.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome Dear Paul, Good Evening, Can you able to help me with this error?
I need to find the duplicates in my PO number column. I tried working with 2 formulas. But both of them throwing me error messages. Could you please able to help to find out what's wrong in this one ?
Both the columns are created under Text/Unmber.
Will be waiting to hear from you.
Thanks in advance
Manuel Jacob.
-
@Navroz Kajani I am not sure exactly what you are trying to accomplish. Are you just wanting to flag rows where the [PO Number] is duplicated?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome - Hello Paul, I need to find the duplicates in the PO number column. Can you help me ?
-
I hope you're well and safe!
Try something like this.
=IF([PO Number]@row = "", "", IF(COUNTIF([PO Number]:[PO Number], [PO Number]@row) > 1, "Duplicate"))
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!
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.
-
@Navroz Kajani Take a look at @AndrΓ©e StarΓ₯'s solution. It is pretty much the same thing I would have suggested.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 376 Global Discussions
- 205 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!