Set Checkbox to Checked based on another Field


#1

I would like to set a checkbox to checked based on if another field has a number in it. Here is the Function I have in a Field called CheckChain.

IF({Chain Amount} = BLANK(), Chain = 0,Chain = 1)

The field Chain is a checkbox, and the field Chain Amount is how many times tire chains are applied. I am using this as a check to be sure the Chain checkbox is checked, if someone forgot to check it and entered an amount.


#2

You can’t do it if the field Chain was a checkbox. You could have the formula like this though:

IF({Chain Amount}, ‘:white_check_mark:’, ‘:no_entry:’ )

The rendering of the text above is buggy for me. Here’s the image:

Alex


#3

How exactly is this entered into the formula field, might I ask?


#4

To enter in the emoji characters:
If you have a Mac, you can bring up an emoji picker by typing Ctrl-Cmd-Space. Alternatively, you can copy and paste emoji from websites such as Emojipedia. (Copy-paste won’t work here as the forum engine replaces emoji with images.)


#5

Woah. I’m aware of the insert character dialogue as I use it often for logical symbols and such, but I didn’t realize it accepted those, especially in a formula field.
That’s nifty.


#6

I would like to do the same thing at PavementPilot. And your workaround solution does not solve the problem.

I have a CRM of sorts and would like to set up a Kanban based upon number of interactions. Interactions are limited to single pick formatted cells. So I have a # of interactions field that reports a number. I would like to build a formula that says if 0=“Check box 1”, 1=Check box 2, 2>Check box 3). That way I can sort my Kanban in columns of number of interactions and see which companies are progressing better or worse then others.