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.

Find more posts tagged with

Sheets

Formulas

Conditional Formatting

Accepted answers

Leibel S

@Joe M.

Use the Character function to reference the quotation marks:

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.