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


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!