Checkbox is ticked when 3 cells match.


I'm looking for a way to make a checkbox ticked when 3 cells all have matching data in.

P/N Actual

P/N OPP LLP list

P/N F12

These should all contain matching part numbers, and if they don't we need it to flag up that they don't.

What's the best way to set up a formula to do this? Been messing around with IF Statements but can't get it working.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!