Need help with seeing if a cell contains the quote symbol.
Options
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.
Best Answer

Use the Character function to reference the quotation marks:
=IF(CONTAINS(CHAR(34), [Column]@row), 1, 0)
Answers

Use the Character function to reference the quotation marks:
=IF(CONTAINS(CHAR(34), [Column]@row), 1, 0)

This worked great thank you for the fix!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!