Hello team
can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value
thanks in advanceoded
Hi Oded,
Try this.
This formula will check one column for duplicates and check the box in a checkbox column. Place the formula in this helper column. You can then use conditional formatting to format the cell(s) or row(s)-
=IF(COUNTIF([Column Name]:[Column Name]; [Column Name]@row) > 1; 1)
The same version but with the below changes for your and others convenience.
=IF(COUNTIF([Column Name]:[Column Name], [Column Name]@row) > 1, 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
many thanks
it's worked as expected ! 100% !
thanks !
Great!
Happy to help!
Andrée
Hello!
What if I wanted to compare one column to a different column checking for duplicates?
I would want a check in the "checkbox column" if "column A" and "column B" had the same information. Is this possible?
Hi,
Not sure I follow!
Can you elaborate?
I tried this and I am getting an #INVALID OPERATION error. I am in the United States.
My row is called Company
My formula is below:
=IF(COUNTIF([Company]:[Company], [Company]@row, >1,1)
Hi @Christopher Pretty,
Try something like this.
=IF(COUNTIF(Company:Company, Company@row) > 1, 1)
Did that work?
I hope that helps!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help 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!
Andree,
Im sorry - but where does this formula need to be typed? Im completely new to smartsheets
I've inserted a new column and put the formula there, but i get #UNPARSEABLE
Hi @Kabir Luthra
Inserting this into a new column is right!
You'll need to update the [Column Name] to be specific to your column name. If you're still getting an error, it would be helpful to see a screen capture with the formula open in the sheet, but please block out any sensitive data!
Cheers,
Genevieve
@Kabir Luthra
I saw that Genevieve answered already!
Let me know if I can help with anything else!
I used this formula and it works great. Thank You!
Hi @Susan Vieira
Excellent!
Glad to hear that it was helpful!
Be safe and have a fantastic day!
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!
Help! Why isn't this working for me?
Hi @Kristy McUmber
I've checked in with our Support team and there is currently a known issue for this exact type of formula if you are evaluating criteria that begins with a 0 or a leading ' apostrophe, as the data in your UPC Code column is formatted.
To fix the formula in the meantime, add an = sign before your [UPC Code]@row criteria, like this:
=IF(COUNTIF([UPC Code]:[UPC Code], =[UPC Code]@row) > 1, 1)
Let me know if this works for you!
Yes! Thank you! That works!
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?