Matching data across multiple cells

Hi all, I feel like this should be pretty easy but I can't seem to work out how to get this done...

I have a sheet with 3 columns that capture different locations - what I am trying to do is return a status/value if all 3 of those locations match, a different value if none match, and again a different value if only 2 match. Is this possible?


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Are all of the columns right next to each other or are they spread out across the sheet? Are you able to provide a screenshot of your column headers as well as some details regarding the actual statuses you would like to output?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!