3 Google Sheet Checkbox Tricks
HTML-код
- Опубликовано: 22 авг 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!
Spacial thanks man
You're welcome!
Great presentation, great formulas, great application!
thank you
Thank you for a very straightforward tutorial. Exactly what I was looking for!
no problem thanks for watching
Great work.
Thank you, very useful
Super helpful! Thanks!
This is a great tutorial, thank you!
no problem thanks for watching
DSM Strength - I would like to see how check boxes that can tbe used to append text in cells to a google docu
thanx !
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
Super useful!
Thanks
thanks dude i finally got it
great thanks
Welcome 😊
Thank you.
You're welcome!
Found this really useful. Thank you for putting this together.
thank you very much for watching! glad it helped you.
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
loved it thanks
Awesome, thanks a lot
no problem thanks for watching
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.
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
This really helped! Thanks
Is it possible to have all checked boxes go to the bottom or vice versa? Need this !
I dont know what you mean
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
How would I add time stamp using the check box function
Great.
thank you for saving our time
glad it helped
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")
I needed this
thank you
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
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?
blessings
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?
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
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
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
hi what is we want to custom format from another worksheet?
*what if?
greatttt
THANK YOU!
how to add checbox automatically if there is another new data?
How do you tick the checkbox via a keyboard? Doing it constantly with a mouse can be slow. Anyone know? :)
Space bar
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.
Knew about Check boxes.But i kearnt about query function too
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?
How do you simply ADD all the checks to get a total?
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
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
I can’t manage to figure out what the character is that your putting in between ( and B2 ..
should be a "$"
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
IF the number is 'zero' automatically check the checkbox. IS there a query for this one ?
if(cell=0, True, False)
👏👏👏
Thank you!
Alyssia benches 365?! Jesus!
👌
thank you