Multiple checkboxes in one cell - Formula for True (Part 2)

This is a follow question - reposting for visibility. While my original question was answered, I'm now having trouble with the formula. This formula seems to be working, however I am expecting it to return symbols. Instead, it is only returning the "text". Anyone have an idea why...? The column type is set to Symbols and restricted to symbol values, but is still showing text. Here is my formula:

=IF(COUNTM(Question@row) = 3, "yes", IF(COUNTM(Question@row) = 0, "no", IF(COUNTM(Question@row) > 0, "hold")))

Here is what I'm seeing

Find more posts tagged with

Sheets

Formulas

Accepted answers

DKazatsky2

Hi @Shawn Church,

The answers need to capitalized.

Tyr this.

=IF(COUNTM(Question@row) = 3, "Yes", IF(COUNTM(Question@row) = 0, "No", IF(COUNTM(Question@row) > 0, "Hold")))

Hope this helps,

Dave

All comments

DKazatsky2

Hi @Shawn Church,

The answers need to capitalized.

Tyr this.

=IF(COUNTM(Question@row) = 3, "Yes", IF(COUNTM(Question@row) = 0, "No", IF(COUNTM(Question@row) > 0, "Hold")))

Hope this helps,

Dave

Shawn Church

Yep - that's it! I used lower case because that is how it is represented in the column type description. Thanks for your help.

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, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.