Two columns match count formula

I am trying to create a formula that can match two columns

For instance

Column 1 name column 2 =yes  


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @Ninfreak

    I'm happy to help. What would you like to do with the two matched columns? Are you wanting to

    1) IF(AND(Column1="name", Column2 = "yes"), do something?


    2) COUNTIFS([column1]:[column1], "name", [column2]:[column2], 1)

    or 3) something else?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!