The Community Search page is currently unavailable. We are investigating this and hope to have a fix as soon as possible. Please use alternate search engines (e.g. Google) or navigate to your profile to find individual posts. Thank you!

Formula is not working Smartsheet, Same formula worked perfectly fine in Excel

IF(ISNUMBER(SEARCH("text"cell)), value_to_return,"")

Can someone please help me to understand why these formula is not working in Smartsheet.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!