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.

Paul Newcome

Smartsheet does not have a SEARCH function.

Try this instead:

=IF(CONTAINS("text", cell), "value_to_return")

MichaelTCA

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)

Paul Newcome

Smartsheet does not have a SEARCH function.

Try this instead:

=IF(CONTAINS("text", cell), "value_to_return")

Yogi

Thanks to @Paul Newcome and MichaelTCA for trying to help me,

=IF(CONTAINS("text", cell), "value_to_return") - This formula worked for me.

Paul Newcome

Happy to help. 👍️