Mark Duplicate value

Genevieve P.

Great, thanks for letting us know! 🙂

Rhiannon Castro

I am looking for a Duplicate function to find matches between a Campaign ID column and the Status column.

Currently using:

=IF(COUNTIF([Campaign ID]@row:Status@row, [Campaign ID]) > 1, 1)

it returns as #UNPARSEABLE

Genevieve P.

https://community.smartsheet.com/discussion/comment/298498#Comment_298498

Hi @Rhiannon Castro

You're missing the row number or ID after the column name for the criteria of what you're looking for in the COUNTIF function:

COUNTIF([Campaign ID]@row:Status@row, [Campaign ID])

Should be:

COUNTIF([Campaign ID]@row:Status@row, [Campaign ID@row])

Try this:

=IF(COUNTIF([Campaign ID]@row:Status@row, [Campaign ID]@row) > 1, 1)

Cheers,

Genevieve

duncbro

Hello, I am having trouble with suggested formula. Any advice is appreciated:

Kelly Moore

Hello @duncbro

Is the above formula returning an Unparseable? I notice you have a semicolon instead of a comma in your formula, whereas all other term separators are commas. It also looks like you have an extra parenthesis on the very end - notice it is black. The last parenthesis will be blue when you have the correct number of parentheses in your formula (this doesn't mean they are necessarily in the right place).

Does correcting those two syntax errors solve your problem?

Kelly

duncbro

Yes it did, thank you. However, it did not return any values and I am sure the column contains duplicate values.

Kelly Moore

try this

=IF(COUNTIFS([SC#]:[SC#], <>"")>1,1)

sorry, I didn't pay attention to your @row criteria. You want it to look at all the cells so this is really reading @cell<>"" (No blank cells).

duncbro

Thank you. The recommended formula highlighted all cells.

Kelly Moore

Sorry, @duncbro. The original formula formula with the @row should have worked- it was a brain blip on my part.

To be clear, this formula returns a zero

=IF(COUNTIFS([SC#]:[SC#], [SC#]@row)>1,1)

You should see a pink parenthesis for the CountIfs, and blue one enclosing the IF statement.

cstangland

https://community.smartsheet.com/discussion/comment/266231#Comment_266231

Thank you Kristy! That "=" is the game changer!