3 Google Sheet Checkbox Tricks

In this video I will show you 3 ways you can use checkboxes in your google sheets to make them more interactive and dynamic. You will learn how to change colors, formulas, and charts using checkboxes.
► Support DSMStrength HERE: www.buymeacoff...
► Purchase Google Sheets Athlete Dashboard: bit.ly/2U0Epgz
SUBSCRIBE TO DSMSTRENGTH: bit.ly/3xRrNH7
[Books I Love] Support the Channel
►Periodization: amzn.to/2mOiBDA
►Strength Coach Guide to Excel amzn.to/2xAEZ4p
►Strength Coach Playbook: amzn.to/2mY9crI
►Principles and Practice of Resistance Training: amzn.to/2mM1Jf6
►High Performance Training for Sport: amzn.to/2mqWb74
[Connect with Me]
►See all Strength Coach Tutorials: bit.ly/2mLU5Bf
►Check our website: www.dsmstrength...
[Social Media]
►Instagram: / dsmstrength
►Twitter: / dsmstrength
►Facebook Page: / dsmstrength

[@eventinerowe3224]

THANK YOU! I'm creating a Gift Planner for people who like to crochet items. I needed a way to calculate how much time a project would take to make. Yet! I need to give choices of minutes, hours or days. I think using the check boxes, and formulas if it equals true is going to work!! Thank you again

[@AliciaMessinger]

This was so helpful, thanks!

[@Simplentertainments]

Thank you for a very straightforward tutorial. Exactly what I was looking for!

[@DSMStrength]

no problem thanks for watching

[@DeniseFer]

Thank you so much, I've been trying to do this for YEARS. Instant subscribe

[@DSMStrength]

So glad it helped

[@zarkosrzic86]

Great presentation, great formulas, great application!

[@DSMStrength]

thank you

[@jeffryan7439]

I did one today that is very useful, using Apps Put a checkbox at Row 1 that adds a new row at the top of the sheet instead of working from the bottom of a long sheet (In my case row 3) It adds a new blank row with same formatting, your sheet always works from top down newest first instead of the opposite

[@yeepers2388]

This is a great tutorial, thank you!

[@DSMStrength]

no problem thanks for watching

[@adamstuartclark]

Found this really useful. Thank you for putting this together.

[@DSMStrength]

thank you very much for watching! glad it helped you.

[@samsal8638]

DSM Strength - I would like to see how check boxes that can tbe used to append text in cells to a google docu

[@ToniaCunningham-y8h]

THANK YOUI!! very helpful!

[@doaahamdy1112]

Thanks alot If I have several colums with a checklist in Excel, how can I copy the checked ones into true and un checked in False for all columns at once?! Thanks in advance

[@meowmeow1081]

Super helpful! Thanks!

[@thomasskraback4977]

thanks dude i finally got it

[@socjhz1]

Thank you, very useful

[@markcole6460]

Great work.

[@andrewnewcombe1908]

Thank That was just the info I wanted. If you could explain pivot tabels that would be excelent

[@DSMStrength]

thanks for watching I have done some videos on pivot tables I believe

[@Lordblanca]

How would I add time stamp using the check box function

[@viktor6772]

thanx !

[@Funuttu]

Spacial thanks man

[@DSMStrength]

You're welcome!

[@ethancorbett4097]

Is it possible to have all checked boxes go to the bottom or vice versa? Need this !

[@DSMStrength]

I dont know what you mean

[@warigato]

loved it thanks

[@WrvrUgoThrUR]

This really helped! Thanks

[@fabriniano]

i dont understand i wrote this down, =if($I2, TRUE, FALSE) and cant click enter, what did i wrong here?

[@89pjanic]

me too haha

[@DSMStrength]

The formula looks correct it should be this: =if($B2, True, False) I would have to see your sheet... likely something stupid that is preventing it from working.

[@emile3209]

@@DSMStrength Hello, i have the same problem, can you check my sheet

[@ryan123004]

Super useful!

[@questionresearch8721]

Thank you.

[@DSMStrength]

You're welcome!

[@sunderjangra4477]

great thanks

[@DSMStrength]

Welcome 😊

[@jorwegs]

Is there a way to do the opposite? Like, if a certain cell has a value greater than zero, then the checkbox checks itself? and when that cell is 0 the checkbox remains unchecked - like an auto checking checkbox?

[@michelecassidy3557]

Hard to see the formulas you used. and they are not in the notes. I have a backpacking list, with #'s(numbers/weights for each item); I use different items on the list depending on where I'm going and need to be able to add up the weight in my pack. So I'd like to check the cells of the items I'm going to take and sum them....so what formula/s would I use?

[@DSMStrength]

Something like sumif(a1:a, b2:b, "true")

[@clarayu1469]

Thanks for sharing. But, I am going to make a sign up sheet for a event. however, there are a some criteria for application. e.g. there are total 6 events for 100 names but each name only can attend one event and each event has only 10 attendee. So, if the event is fully occupied, how to block the other person of checkbox in order to prevent exceed sign-up.

[@SpawnViper4]

This might be a little late but I believe there is a way to avoid/limit multiple values with the "UNIQUE" or "CHECK IF" functions. Hope this helps with future projects.

[@grunkale117117]

Great video! Is there a way to make a query to display the data only if multiple checkboxes are true and not just one checkbox?

[@philtoa334]

Great.

[@tokohawe77]

Nice. How do u remove the 'true' in ur 3rd example as I'm trying to make a shopping list where the checkbox chooses the ingrediantse thanks

[@LogisticaGaspasaCln]

Awesome, thanks a lot

[@DSMStrength]

no problem thanks for watching

[@mayurparmar]

How to run query on multiple column , like if i have check box in B , D, F and i want every value that is true in all these column

[@ShawnMarris]

I have a shipping schedule and I am wondering when it is shipped if I were to check the box could I have a new sheet called shipped and how do I do this?

[@MohiuddinAhmed-i6m]

Thanks

[@raihanrabbani_]

how to add checbox automatically if there is another new data?

[@noahrod3363]

I needed this

[@DSMStrength]

thank you

[@pf7148]

thank you for saving our time

[@DSMStrength]

glad it helped

[@muatring]

Is it possible to give a checkbox a value other than True/False? I want for example, to give my checkbox a value of .4 if True and 0 if False, and then use it in a mathematical formula in the future for something else.

[@DSMStrength]

Yes you should be able to edit in data validation

[@noahziegler3478]

How do you simply ADD all the checks to get a total?

[@2minuteschool929]

Please add key words and playlist so that we can see you better👍👍

[@DSMStrength]

Thank you for the feedback, I am not quite sure what you mean however? could you clairify?

[@Emmie1223]

@@DSMStrength captions

[@irontale1834]

how do I do math with it so I sometimes need to take stuff to the dump I want, "will you dump" true it adds the cost automatically to the customers total or if false doesn't add it at all

[@SpawnViper4]

I believe you can use the explanation in the video. Instead of "True" name it "dump", if "False" name "don't dump". Then refer to the last function of the video where he explains the "Charts" to created one for "Dump" & "Don't Dump", see if that helps.

[@reubenellis8678]

How do you tick the checkbox via a keyboard? Doing it constantly with a mouse can be slow. Anyone know? :)

[@Reassign]

Space bar

[@JoostVerberne]

Hi! great video! I have a question, for some reason (even when copying your sheet cell by cell and the exact formula, my sheets give me an error when using the formula you're using for averageifs. Any idea why?

[@DSMStrength]

could you paste your formula? I am sure you have missed a comma or something small and hard to see.

[@ArisKaratarakis]

Bit late to answer your question, but I just saw this video and had the same issue; it seems like the GSheets formula order has changed to (criteria range, criterion, [average_range]), so you should first choose the range of the checkboxes, then the criterion (TRUE), and then the numbers range.

[@Lordblanca]

blessings

[@theeducationist2901]

Knew about Check boxes.But i kearnt about query function too

[@wansaniyizzatwanarifin4555]

hi what is we want to custom format from another worksheet?

[@wansaniyizzatwanarifin4555]

*what if?

[@CurioCreativeAgency]

How do I write a script where they check the box, a popup comes up and they type their name in to agree to terms of accepting that check box?

[@DSMStrength]

I am sorry i do not know

[@alexisgarcia7319]

i cant find a way to make a copy of my document and keep the checkboxes, when i make a copy, all the checkboxes shift to "TRUE/FALSE" words instead of the checkboxes itself

[@DSMStrength]

i believe if you make a duplicate of the sheet it should work but not sure haven't tried it

[@lilydinh5679]

Hi! I was wondering if there was any way to move the checkboxed data to a new sheet like how you moved it to the chart?

[@DSMStrength]

you should be able to duplicate the sheet?

[@Sinidora]

I can’t manage to figure out what the character is that your putting in between ( and B2 ..

[@DSMStrength]

should be a "$"

[@onomatopoeia6787]

IF the number is 'zero' automatically check the checkbox. IS there a query for this one ?

[@DSMStrength]

if(cell=0, True, False)

[@JonathanDeCollibus]

greatttt

[@DSMStrength]

THANK YOU!

[@cecisharp]

Hi there! My check box is in E2, and I'm putting the following formula: if($E2, TRUE, FALSE) but nothing happens. I can't see what I'm doing wrong!

[@cecisharp]

No worries, I didn't put the equals sign, I'm an idiot lol

[@DSMStrength]

So often it is just a typo

[@japaneseambience8836]

👏👏👏

[@DSMStrength]

Thank you!

[@yveisbomb]

👌

[@DSMStrength]

thank you

[@SmokeyJo33]

Alyssia benches 365?! Jesus!