3 Google Sheet Checkbox Tricks

[@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

[@zarkosrzic86]

Great presentation, great formulas, great application!

[@DSMStrength]

thank you

[@yeepers2388]

This is a great tutorial, thank you!

[@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

[@adamstuartclark]

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

[@DSMStrength]

thank you very much for watching! glad it helped 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

[@meowmeow1081]

Super helpful! Thanks!

[@markcole6460]

Great work.

[@ToniaCunningham-y8h]

THANK YOUI!! very helpful!

[@socjhz1]

Thank you, very useful

[@samsal8638]

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

[@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

[@thomasskraback4977]

thanks dude i finally got it

[@ryan123004]

Super useful!

[@Funuttu]

Spacial thanks man

[@DSMStrength]

You're welcome!

[@WrvrUgoThrUR]

This really helped! Thanks

[@warigato]

loved it thanks

[@BennettRussell]

I am able to add check boxes to a group of cells. I am working on a monthly budget. In cells S13 to S21, I have check boxes. These re-present bills that are paid each month automatically. In cells in the M column is my transactions. What I would like to if it is possible, once a bill is paid for a particular account, the check boxes will now be true. I've tried the if function, Vlookup and conditional format. I get error like #REF, #NAME, N/A, and #ERROR. So, can this be done? Thank you.

[@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

[@LogisticaGaspasaCln]

Awesome, thanks a lot

[@DSMStrength]

no problem thanks for watching

[@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

[@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")

[@Lordblanca]

How would I add time stamp using the check box function

[@viktor6772]

thanx !

[@noahrod3363]

I needed this

[@DSMStrength]

thank you

[@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

[@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?

[@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?

[@sunderjangra4477]

great thanks

[@DSMStrength]

Welcome 😊

[@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

[@questionresearch8721]

Thank you.

[@DSMStrength]

You're 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?

[@pf7148]

thank you for saving our time

[@DSMStrength]

glad it helped

[@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.

[@philtoa334]

Great.

[@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.

[@MohiuddinAhmed-i6m]

Thanks

[@wansaniyizzatwanarifin4555]

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

[@wansaniyizzatwanarifin4555]

*what if?

[@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?

[@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.

[@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

[@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

[@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

[@reubenellis8678]

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

[@Reassign]

Space bar

[@raihanrabbani_]

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

[@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

[@Lordblanca]

blessings

[@noahziegler3478]

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

[@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

[@JonathanDeCollibus]

greatttt

[@DSMStrength]

THANK YOU!

[@Sinidora]

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

[@DSMStrength]

should be a "$"

[@theeducationist2901]

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

[@onomatopoeia6787]

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

[@DSMStrength]

if(cell=0, True, False)

[@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

[@japaneseambience8836]

👏👏👏

[@DSMStrength]

Thank you!

[@SmokeyJo33]

Alyssia benches 365?! Jesus!

[@yveisbomb]

👌

[@DSMStrength]

thank you