10 Ways To Use Checkboxes In Numbers

Checkboxes are a useful tool in Numbers that allow you to simply indicate a true or false value. You can use that as data, to sort, filter or alter the outcome of formulas.

Comments: 12 Responses to “10 Ways To Use Checkboxes In Numbers”

    harry
    1 year ago

    Gary , is there a way to prevent user from checking a box if the previous check box is not checked. in your example you could not check received if one of the prior boxes is not checked?

    1 year ago

    Harry: No. There is no way to do that. For one thing, there is no distinction between a "user" and someone more powerful than a "user" when it comes to a Numbers document.
    What you can do though is have a cell that uses an IF function to display a noticeable error message when things aren't being done right.

    Jimmy Marchini
    1 year ago

    Is there a way to use conditional formatting for a cell related to its corresponding checkbox cell. For example... in the table you use in this video... is there a way by clicking the checkbox in cell E3 it will conditionally change the format color of the font in cell D3 ($300).... or perhaps change the color of the D3 cell itself, or even both.

    1 year ago

    Jimmy: You can do that if you have F3 using an IF function to set it to the value of D3 if E3 is checked. Then the conditional highlighting for D3 has the criteria that it should be highlighted if D3 has the same value as F3. Then hide column F if you like. https://macmost.com/numbers-conditional-highlighting-based-on-other-cell-values.html

    Jimmy Marchini
    1 year ago

    Thanks, Gary...that works. Of course now I have to berate myself for not thinking of that myself.

    John
    1 year ago

    Gary, thanks. This was really good information. I use Numbers often but I don’t look into the details often enough. Numbers is actually quite awesome.

    Mik
    10 months ago

    Hey, is there a way to show checked boxes? Right now, they just dissapear. I'd like them to appear at the bottom of the list. Thanks Gary for explaining things so well!

    10 months ago

    Mik: Not sure what you are dealing with. They shouldn't disappear. Not sure what you mean by "appear at the bottom of the list" at all.

    Dawn
    5 months ago

    Hi, I'm trying to create a checkbook register with a "checkbox" option so it only calculates the balance when it is marked true. I've successfully made the spreadsheet and the formulas work for a running balance, but I would like the option to the balance calculated only when the checkbox is marked "true." I'm at a loss and have tried some SUMIF but not quite figuring it out.

    5 months ago

    Dawn: I've got a section in this video that deal with SUMIF. I would work through that, using my example to understand how SUMIF works, and then try it in your own document.

    Néman
    4 months ago

    I have a table with the following numbers: 100 -50=50. Is it possible to check a checkbox next to -50 so that -50 is considered as output. So when -50 is ticked then the result is 100 because -50 is no longer subtracted. Thanks for help!!!

    4 months ago

    Néman: You can't do it in the same cell. You would use multiple columns for this and an IF function. But it is hard for me to say much more without knowing what you are actually doing here.

Comments Closed.