3 Google Sheet Checkbox Tricks
Вставка
- Опубліковано 23 сер 2024
- 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
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
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
Thank you so much, I've been trying to do this for YEARS. Instant subscribe
So glad it helped
THANK YOUI!! very helpful!
Great presentation, great formulas, great application!
thank you
Thanks
Thank you for a very straightforward tutorial. Exactly what I was looking for!
no problem thanks for watching
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
DSM Strength - I would like to see how check boxes that can tbe used to append text in cells to a google docu
Thank you, very useful
Super helpful! Thanks!
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.
This is a great tutorial, thank you!
no problem thanks for watching
Found this really useful. Thank you for putting this together.
thank you very much for watching! glad it helped you.
Great work.
How would I add time stamp using the check box function
Spacial thanks man
You're welcome!
Thank That was just the info I wanted. If you could explain pivot tabels that would be excelent
thanks for watching I have done some videos on pivot tables I believe
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
thanx !
i dont understand i wrote this down, =if($I2, TRUE, FALSE) and cant click enter, what did i wrong here?
me too haha
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.
@@DSMStrength Hello, i have the same problem, can you check my sheet
thanks dude i finally got it
Super useful!
Thank you.
You're welcome!
great thanks
Welcome 😊
how to add checbox automatically if there is another new data?
loved it thanks
This really helped! Thanks
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
Knew about Check boxes.But i kearnt about query function too
Awesome, thanks a lot
no problem thanks for watching
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?
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?
Is it possible to have all checked boxes go to the bottom or vice versa? Need this !
I dont know what you mean
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?
Something like sumif(a1:a, b2:b, "true")
Great.
blessings
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
I needed this
thank you
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?
Please add key words and playlist so that we can see you better👍👍
Thank you for the feedback, I am not quite sure what you mean however? could you clairify?
@@DSMStrength captions
hi what is we want to custom format from another worksheet?
*what if?
thank you for saving our time
glad it helped
How do you simply ADD all the checks to get a total?
How do you tick the checkbox via a keyboard? Doing it constantly with a mouse can be slow. Anyone know? :)
Space bar
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.
Yes you should be able to edit in data validation
Alyssia benches 365?! Jesus!
greatttt
THANK YOU!
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?
I am sorry i do not know
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?
could you paste your formula? I am sure you have missed a comma or something small and hard to see.
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.
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?
you should be able to duplicate the sheet?
I can’t manage to figure out what the character is that your putting in between ( and B2 ..
should be a "$"
IF the number is 'zero' automatically check the checkbox. IS there a query for this one ?
if(cell=0, True, False)
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!
No worries, I didn't put the equals sign, I'm an idiot lol
So often it is just a typo
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
i believe if you make a duplicate of the sheet it should work but not sure haven't tried it
👏👏👏
Thank you!
👌
thank you