Use Checkboxes in Google Sheets to Toggle Numbers in or out of a calculation

Get my Google Sheets Deep Dive Course Here:

Get more great content on my website:

Index

0:34 Screen sharing

0:43 Insert menu, choose check box

1:03 When unchecked or checked the check box

2:13 What happens when Seth unchecks the boxes in the example

2:30 Clearing a formula and rewriting it

3:24 Copy the items down to copy formula

3:37 Overall result for using checkboxes

This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Nerd Enterprises, Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Nerd Enterprises, Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

[FarsightedEntrepreneur]

This was exactly what I needed, thank you! Love nerding out on sheets.

[JasonCotting]

Thank you. Was looking on how to use check boxes to indicate a monthly savings transferred was made while looking to hit a certain amount.

[astrade]

Hello!

I had a question regarding a specific case:
Let's say:
You have 4 checkboxes
Above them there is the following
"Add"
"Subtract"
"Reset"
"Submit/Audit"
At the VERY end, there is a white cell at 0
When the checkbox is selected (Example "Add")
It will add +1
IF THE CHECKBOX IS PRESSED AGAIN
It will add +1
Meaning that value should show 2
The subtract works the same way
Just, well subtract
THE RESET is when the value in the cell is set to 0
And the "Submit/Audit"
Is the spreadsheet will look at what is in that cell, and place it in another spreadsheet's cell.

Is it possible to even do that?

[MikeZwaneveld]

For me, when I put the comma, the formula disappears and it gives a error

[idabagusgdetirtayogayatindra]

Thank your for the reply, is this still can be use? because i try it but, nothing happens

[tumpahteh]

Hello! thank you so much for the amazing guide, I want to know if you can make the formula applicable for multiple cells? for example, instead of only C2 we make it C2:F2 and so on. I've trie but it doesnt work for me. Thank you in advance!

[danielaordonez]

Hi Seth!, thanks so much for this awesome video, helped clear up so much. I do have a question however, what formula could be used to take the data from one sheet and onto another?

For example taking a checkbox from one check and making it a number on another. I'd really appreciate the help or any input!

[thailerrhyne]

Thank you!

Question, Can you apply this to multiple check boxes, that all enter the sum into one cell? For example, B3 through Z3 all have check boxes that if marked "true" would add "1" per "true" value to the final cell, lets call it AA?

[Lordblanca]

Help. Im in need of a simple formula I think it is simple. I want to use a check box to (-) minus from the total every time the box is check. ie. Total =100. Click check box = 99... And every time I click another check box in the column it minus from the total. And the results show up in a different cell. Can you help Please Thank you

[Robin-swis]

Hello, Thanks for the video! Can you explain how to return multiple values? For example, if you had three columns: COGS 2021(value $8, 704.96), COGS 2022 ( value $10, 704.96), COGS 2023(value $12, 704.96), could you make a formula that would return $8, 704.96, $10, 704.96, $12, 704.96 with commas in cell D2?

[thomaslukasik]

Is it possible for to create an action for a checkbox, that if the value is above or below (lets say 0), it checks the box for you automatically? as an example if b1 is -20 then the checkbox "loss" is checked?

[niloc]

Amazing!! Thanks for sharing how to use checkboxes on Google sheets.