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.
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 457 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!