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")
Best 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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!