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
Yogi
✭✭
IF(ISNUMBER(SEARCH("text", cell)), value_to_return,"")
Can someone please help me to understand why these formula is not working in Smartsheet.
Tags:
Best Answer
-
Smartsheet does not have a SEARCH function.
Try this instead:
=IF(CONTAINS("text", cell), "value_to_return")
Answers
-
Hello @Yogi
I don't see anything wrong with the structure of the syntax.
SEARCH() is not a function within Smartsheet.
FIND() is nearly the same thing. Try replacing SEARCH with FIND("text",@cell)
-
Smartsheet does not have a SEARCH function.
Try this instead:
=IF(CONTAINS("text", cell), "value_to_return")
-
Thanks to @Paul Newcome and MichaelTCA for trying to help me,
=IF(CONTAINS("text", cell), "value_to_return") - This formula worked for me.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!