Duplicate Check Formula


Hello There,

I have created a column for duplicate check, It will flag the as red if both conditions are true

Condition 1 : CPR ID Duplicate

Condition 2 : Amount Duplicate

Formula which is giving me error:

=IF(AND(COUNTIF([CPR ID#]:[CPR ID#], [CPR ID#]1) > 1, IF(COUNTIF(Amount:Amount, Amount1) > 1, 1)))

I think i am not using AND function properly

@Paul Newcome @L@123

Please help, Thanks


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!