Identify duplicates with multiple criteria

Options

Hi,

I need to identify rows that have the same Invoice No (text column), the same Supplier Name (text column), but different Funding Date (date column) and flag the row.

This is the formula I attempted that did not work:

=IF(COUNTIFS([Invoice No]:[Invoice No], [Invoice No]@row, [Supplier Name]:[Supplier Name], [Supplier Name]@row, [Funding Date]:[Funding Date], <>[Funding Date]@row) > 1, 1)

Any help would be much appreciated. Thank you!



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!