Workflow to change value in checkbox column

Bleakley McDowell

How do I create a workflow to change a value in a checkbox column?

Once I set my trigger, which is a specific drop-down choice in another column on the same sheet, I select my action and choose "change cell value" but the choices of columns in to change the value in only include text and dropdown columns. I don't see anything for checkbox column.

Bleakley McDowell

@Mark.poole Ok. I think I found the issue. I was using the flag icon for the checkbox (and my other checkbox columns that also were not showing up were using the star) and I changed it to the regular "check" symbol and now it works. Seems like a bug!

Mark.poole

@Bleakley McDowell

Is there a specific reason to use a workflow instead of an IF statement? also I am not sure why you cant see the checkbox column. It should be there. While the dropdown for it is text. The text is "Checked" or "Unchecked".

If you just added the Checkbox column be sure that the sheet was saved before starting to build the workflow.

Bleakley McDowell

@Mark.poole The workflow seems more direct but I suppose I could use an IF statement. Thanks for the suggestion!

I have no idea why I'm not seeing any checkbox columns. The column is not new to the sheet. I see column options for Text/Number and Dropdown (single select) but no checkbox. Weird.

Andrée Starå

https://community.smartsheet.com/discussion/comment/439534#Comment_439534

Hi,

I hope you're well and safe!

Are there any formulas in the checkbox column?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Bleakley McDowell

@Mark.poole Ok. I think I found the issue. I was using the flag icon for the checkbox (and my other checkbox columns that also were not showing up were using the star) and I changed it to the regular "check" symbol and now it works. Seems like a bug!