Duplicate Check Formula

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!