HIGHLIGHT DUPLICATE ENTRIES

BRANT GRINER

Hey i have a column of p.o. #s that i would like to be highlighted a certain color if someone enters the same # in and column below or above can someone help me figure out how to do this please.

i posted a picture of where the duplicate is and how to format looks

SteyJ

Create a new column called duplicate, and set it to checkbox to check for duplicate. Use this formula, and convert to column formula:

=IF(COUNTIF([P.O. Number (if applicable)]:[P.O. Number (if applicable)], 
CONTAINS(@cell, [P.O. Number (if applicable)]@row) >= 2, 1, 0)

Now, use conditional formatting -> If duplicate column is 1, then highlight row

BRANT GRINER

your gonna have to explain a little more for me lol im not so up to speed on how to do all of this. how do I make column formula? and when i copied your Formula into the first cell of my new column it didnt work. so which parts of your formula do i need to enter correct values for?

SteyJ

https://community.smartsheet.com/discussion/comment/410270#Comment_410270

Right click on a cell with a formula, then click convert to column formula.

What is the error that it gives you, after you convert to column formula?

BRANT GRINER

SteyJ

https://community.smartsheet.com/discussion/comment/410275#Comment_410275

try replacing with this formula:

=IFERROR(IF(COUNTIF([P.O. Number (if applicable)]:[P.O. Number (if applicable)], 
CONTAINS(@cell, [P.O. Number (if applicable)]@row) >= 2, 1, 0), 0)

Duplicates should show now, and you can conditional format based off of the value.

BRANT GRINER

i still get the same error message

BRANT GRINER

is the Paratheses in my column title messing up the formula?