Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Identifying Duplicates - Matching criteria across 3 Columns

I've used formula given in similar discussions on this topic. However, The formula does not seem to work 100% for what I'm trying to achieve.

=IF(AND(COUNTIFS(BUILDING]:[BUILDING], BUILDING@row) > 1, COUNTIFS([FLOOR]:[FLOOR], FLOOR@row) > 1, COUNTIFS([ROOM]:[ROOM, ROOM@row) > 1), 1, 0)

The blue cells are the duplicates. The formula (above) identifies all the cells except 2. This is incorrect. Can anyone provide some advice on where I'm going wrong please?

Thank you.

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions