Unparseable errors

Kurt Robohm

I've tried a number of formulas that should work but keep on getting unparseable errors. [current process stage] does light up as found, so am thinking it's not an issue with using a column name that can't be found. Some of the formulas tried were:

=SEARCH("S1", [Current Process Stage]@row

=IF(ISNUMBER(SEARCH("S1", [Current Process Stage]@row)), 1, 0)

Current process stage column contains S1 plus some other text.

Paul Newcome

SEARCH is not a valid function in Smartsheet. Try a FIND function instead.

Paul Newcome

SEARCH is not a valid function in Smartsheet. Try a FIND function instead.