Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula to check if cell contains text string + value in another cell
For example, the value in column 4 row 2 is "xxxxx_email [email protected]_xxxxx"
The value in column 2 row 2 is "[email protected]"
I need a formula that checks if column 4 row 2 contains "email [email protected]" by crosschecking the value in column 2 row 2 and using the text string "email address="
I have it worked out in Excel using a COUNTIF statement, but it does not seem to translate well into Smartsheet.