Problem with formula in checkbox.

SanyaCLAUS

I have a formula in a cell check box:

=IF(COUNTIF(b3:b4, true) > 0, true, false)

It works great, but when you click on it, the formula is removed. It can be pressed accidentally, so I would like to protect myself.

Nothing checked.^|^

Only Monday3 is checked, and also Monday2 checked automatically. ^|^

I checked Monday2, and nothing else ^|^

Monday2 not working after checking(((((^|^

Andrée Starå

Hi @SanyaCLAUS

I hope you're well and safe!

I'd recommend converting it to a column formula because it can't be changed manually.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Christian G.

The sheet sees the check you input as replacement for the formula. With checkbox's formula, it is better to have a Column formula and not Cell formula. Otherwise, you will always get that situation.

It is the same as a text formula. You can type "=Description@row" and it will copy the text or you can type anything else and the formula will disapear.

SanyaCLAUS

SanyaCLAUS

@Andrée Starå ,@Christian G. But I need to use separate ranges for each checkbox, for example monday5 in my screenshot will use a function for its range that is different from monday2... and also the cells of this range should be without a formula at all.

Andrée Starå

@SanyaCLAUS

The only way to solve it then would be to use so-called helper columns to split it up.

Would that work/help?

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!