Value for updating a checkbox

Zac Muir

Hello,

I am trying to pass in values via Zapier to update a checkbox type field.

I have restricted the column so that it will only accept checkbox values.

What value should I pass in to check/uncheck the box?

I have tried Yes, No, True, False, and some variations in all caps.

Thanks!

-Zac

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi Zac,

I'm not that familiar with Zapier, but in our API documentation the checkbox values are identified with the following:

Checked = true

Unchecked = false

(You can read more about this in our API Documentation, here.)

If this doesn't work, the Checkbox values in formulas are as follows, so you could try this:

Checked = 1

Unchecked = 0

(You can read about this in our Formula FAQ article, here.)

Let me know if either of these have worked for you!

Cheers,

Genevieve

Boolean

Hello I am very interested in solving this problem as well. @Zac Muir, were you ever able to solve this with writing value in a checkbox to s SmartSheet column?

Boolean

After trying several different ideas. I HAVE A SOLUTION!

It turns out that all the versions for a "check" (i.e. 1, TRUE, True, true) work as well as the opposite (i.e. 0, false, False, and FALSE).

You just have to turn off the setting in the column properties that says, "restrict to checkbox use only"

Screen Shot 2021-12-23 at 7.46.01 AM.png

Screen Shot 2021-12-23 at 7.46.52 AM.png

Brett Wyrick

I don't use Zapier, but I use Power Automate and utilizing lower case true and false appears to work for me.

macandcheeze88

Has something changed recently? I am using CozyRoc and have tried all versions of True and Boolean 1 (and all versions of false/0) and cannot get the check box to populate. I don't have the restrict checkbox use option selected (but I did try both ways just incase something has changed there).

Sorry for the old post, but this is now an issue for us and it appears the same item was found a few years back.

Genevieve P.

Hi @macandcheeze88

"true" and "false" (lower case) should be the correct ways to pass a checked box or blank box into a checkbox column. Or, as you noted, 1 and 0.

If this isn't working for you with your integration, you could always populate a text/number column with helper text then use a Smartsheet Workflow to auto-check the box in that row when that helper cell changes.

Cheers,
Genevieve

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