Duplicate data formula which references two values

Hello Community,

I am trying to find duplicate invoice numbers for the same client within two of my sheets.

I need to show if there have been any duplicate invoices for clients using two criteria but am unsure how to create the formula. I want this information to show in a checkbox form.

=IF(COUNTIF([Invoice #]:[Invoice #], [Invoice #]@row, Name:Name, Name@row>1, 1,0))

Appreciate any support on this.

Best wishes,

Chloe

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!