Need help with seeing if a cell contains the quote symbol.

Joe M.

I want to locate " in a cell but Smartsheet wont allow me to run the following:

=IF(CONTAINS(" " ",[Column]@row),1,0)

Is there some sort of symbol that will allow me to reference this in the quotations of the formula or is there another way to locate this symbol in a cell that I am missing? Using this in a helper column to conditionally format invalid data formats. Any help is greatly appreciated, thank you.

Leibel S

@Joe M.

Use the Character function to reference the quotation marks:

=IF(CONTAINS(CHAR(34), [Column]@row), 1, 0)

Leibel S

@Joe M.

Use the Character function to reference the quotation marks:

=IF(CONTAINS(CHAR(34), [Column]@row), 1, 0)

Joe M.

@Leibel Shuchat

This worked great thank you for the fix!