Check Box Selected / Not Selected = YES or No

High Smartsheets Community,

Question. Is there a formula for if a check box in a column is selected that it would return an answer of "yes" in another column and vice versa, if a check box is not selected it would return an answer of "no." I know I can do a drop down, but there are some other factors that require me to have a check box column.

Thanks, and I hope you all have a great weekend!

Find more posts tagged with

Accepted answers

ker9

Hi @Anthony DAmbrosio

Checkboxes use a 1 for True (yes) and a 0 for False (no).

Formula: =IF(Chkbx@row = 1, "Yes", "No")

Change "Chkbx" to your column name. If your column name is more than one word it will need to be wrapped in brackets like this: [Column Name]

You can make this a column formula so that it occurs on every row.

Hope this helps!

All comments

ker9

Hi @Anthony DAmbrosio

Checkboxes use a 1 for True (yes) and a 0 for False (no).

Formula: =IF(Chkbx@row = 1, "Yes", "No")

Change "Chkbx" to your column name. If your column name is more than one word it will need to be wrapped in brackets like this: [Column Name]

You can make this a column formula so that it occurs on every row.

Hope this helps!

Anthony DAmbrosio

@ker9 That worked! Thank you!

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.