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

Anthony Q

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")

SteyJ

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")

SteyJ

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")

Anthony Q

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