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.
Help Article Resources
Check out the Formula Handbook template!