How to match two columns with text and return "match" or "no match"

Anthony Q
Anthony Q ✭✭
edited 02/15/24 in Formulas and Functions

Hello, I used the formula below to match text in two columns. I can't seem to find a formula in smartsheet that is similar. Please let me know what formula works best with matching two text columns.


=IF(EXACT([TSA Scope Description (NEW)]9,[TSA Scope Description (Old)]9),"Match","No Match")

Best Answer

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 02/15/24 Answer ✓

    Try this:

    =IF([TSA Scope Description (NEW)]9 = [TSA Scope Description (Old)]9, "Match", "No Match")
    

    Alternatively, if you're doing multiple rows, you can use:

    =IF([TSA Scope Description (NEW)]@row = [TSA Scope Description (Old)]@row, "Match", "No Match")
    


    Sincerely,

    Jacob Stey

Answers

  • SteyJ
    SteyJ ✭✭✭✭✭✭
    edited 02/15/24 Answer ✓

    Try this:

    =IF([TSA Scope Description (NEW)]9 = [TSA Scope Description (Old)]9, "Match", "No Match")
    

    Alternatively, if you're doing multiple rows, you can use:

    =IF([TSA Scope Description (NEW)]@row = [TSA Scope Description (Old)]@row, "Match", "No Match")
    


    Sincerely,

    Jacob Stey

  • @SteyJ thank you! This worked perfect. Just getting the hang of all the smartsheet formulas. Thanks again!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!