Google Sheets - CheckBoxes - Column of Checkboxes, Dynamic Checklist with Functions & Formulas

Поділитися
Вставка
  • Опубліковано 26 сер 2024

КОМЕНТАРІ • 98

  • @Mo-is9ko
    @Mo-is9ko 3 роки тому +1

    I feel so smart simply by watching this whole video. Thank you so much!

  • @angelawood2022
    @angelawood2022 4 роки тому +3

    I'm a new fan and subscriber of your tutorials. Thanks for making them! Particularly like watching the background steps as you're prepping data to be used for the main lesson. Learning helpful timesavers there as well (ex. =UNIQUE(C:12:CXX)) to return text required for your table in lieu of typing everything out or copy/pasting from a hunt & peck exercise like I would have done.

  • @phaedra426
    @phaedra426 3 роки тому

    This was awesome. I couldn't find this info in the support forums. Thanks!

  • @markes1976
    @markes1976 3 роки тому +2

    May I suggest when you create these tutorials,s if you could also share the Google sheet as well in view mode, so people can copy and use this?
    Love your training, very good, and easy to follow
    Keep them coming
    Mark

  • @lienphan6446
    @lienphan6446 3 роки тому

    Oh my God you made me become a genius of myself! Thank you so so much! I can't thank you enough!!! Thank you!

  • @NB_Miraj
    @NB_Miraj 5 місяців тому

    Really that much valuable content sir! ❤ from India

  • @hemantsonawane153
    @hemantsonawane153 3 роки тому

    thanks brother.. all ur videos opened a whole new world for me.. i am doing many things nowadays effectively. thanks again.

  • @timnguyen5294
    @timnguyen5294 2 роки тому

    This is very helpful. For faster method, you could also approach this example with pivot table. Though, I believe this method will be ideal if you have to manually review the "checkbox", such as employee commissions and inventory.

  • @pancux670
    @pancux670 3 роки тому

    You are awesome at Google sheets. Thanks

  • @funnyfacestudio
    @funnyfacestudio 3 роки тому

    The Tutorial is very good, it's just a shame youtube are making it impossible to watch these videos with the amount of advertising.

  • @Flooperbass
    @Flooperbass 6 років тому +3

    Thanks for your videos. It woud be interesting to see how to publish your own script as an ad-on for google spreadsheets. Thanks!

  • @suraj_m4656
    @suraj_m4656 5 років тому

    it really helpful and I had used your formula for my project it makes very easy. I feel really thankful for that, You really a good teacher.

  • @c.k.mishra7643
    @c.k.mishra7643 3 роки тому

    Wow very useful tricks

  • @wonkibonki948
    @wonkibonki948 4 роки тому

    Great video. Helped me a lot!

  • @dauletstw
    @dauletstw 6 років тому

    Thank you very much! Keep going to make tutorials, sir!

  • @walterpaiva719
    @walterpaiva719 6 років тому

    Your videos are the best

  • @killerfox513
    @killerfox513 4 роки тому +1

    I'm wondering how I can make it so I have a number let's take 500 for example in a box then I have 5 check boxes and each one I want to have a different value and it takes those values and adds them up to then multiply onto the 500. Is that possible?

  • @ivanlovera
    @ivanlovera 5 років тому

    Excellent tutorial, thank you very much!

  • @GV-gn3mj
    @GV-gn3mj 10 місяців тому

    Hi. Is there a way to have 2 columns of checkboxes and if we mark one of them not allow the user to mark the other checkbox? Have that restriction?

  • @cpidgeon1970
    @cpidgeon1970 2 роки тому

    how do you use an if statement for checkboxes eg. if check box in column I is false return values in columns a:d?

  • @robertmaluka2763
    @robertmaluka2763 6 років тому

    I like this I would have put in a filter on top of this so just the region will show.

  • @sabellaarteam5385
    @sabellaarteam5385 2 роки тому

    Hi what if the data is from another sheet? how to highlight the data from sheet A while the tickboxes is in sheet B?

  • @k-ray6989
    @k-ray6989 Рік тому

    so i need help.. i have a checklist for a list of cards and their details ( so each row has 3-4 columns of separate data) i need for any checked cards and their details to appear in a chart, or table, or on a different sheet, or even on the same sheet. I just need every checked item to show up somewhere else

  • @tititiger2023
    @tititiger2023 5 років тому +2

    Hello Mr.sir
    i reguest to you show how to use check box for copy data or text in a sheet it's into another sheets.

  • @dustonmeyer3770
    @dustonmeyer3770 3 роки тому

    I have a checkbox in column E I know how to make check boxes and I know how to make it so if I check it I can turn column C red. What I dont know how to do is if I have a checkbox in E and also in F if just E is checked it is red, if just F is checked it is blue, but if both E and F are checked it turns Green. I have the checkbox values set to 5 so E=5 and F=5 but both E and F = 10 what is the formula to change the color of a column when 2 or more check boxes are checked

  • @MauricioHernandez87
    @MauricioHernandez87 3 роки тому

    what about the reverse, if an item is yes check the box or if an item is not uncheck the box. you only covered one area.

  • @lucianopessanha7437
    @lucianopessanha7437 2 роки тому

    could you give an example of using the checkboxes as a radio button. It could be by appscripts. If possible two radiobuttons (with 5 alternatives) in the same column. Thank you very much in advance.

  • @ABBYMATHEWTEAM
    @ABBYMATHEWTEAM 2 роки тому

    love it -

  • @jorikaish
    @jorikaish 3 роки тому

    How allow only one of 6 checkboxes to be checked ??

  • @Lordblanca
    @Lordblanca Рік тому

    Nice video. Do you have a formula that would automatically minus from a total every time a box is checked with out changing the value of the box.63-checkbox =62... thanks

  • @FreeLooK
    @FreeLooK 5 років тому

    That was a freaking great video.

  • @tuanmanh7845
    @tuanmanh7845 4 роки тому

    Thank you so much!
    Hope you response my problem. How can i make checkboxes working like Slicer in Excel?

  • @Tcman95
    @Tcman95 5 років тому

    How can I make a checkbox trigger conditional formatting to mask a range of cells. Basically I want to make the cells change to black when pressed.
    Example
    If Checkbox True, Then
    (Cells A1:Z10) Conditional Formatting Black.

  • @riteshpandey5082
    @riteshpandey5082 6 років тому

    Very Use full

  • @samuchevres6781
    @samuchevres6781 4 роки тому

    Hello, I want to make a formula that in order to a checkbox be marked other droplist row have to be answered. Is that possible?

  • @markuswinter-cdps3008
    @markuswinter-cdps3008 4 роки тому

    Thanks so much for your videos. They are very well done, and informative. I have a question as it relates to checkboxes and loops (for loops). I have a column (A) of checkboxes that by default are unchecked (false). I attempting to write a script where I if a checkbox is checked, blank cells get added to the row the checkbox is on (on a separate sheet). I have the basic script written, but what I'm running into is when I check checkbox 2, 3, 4 etc, the program re-evaluates every checkbox that is already checked (true) and adds extra cells. For instance, if I check A1, it adds cells to B1:G1...perfect. If I then also check A2. It will add B1:G1 again AND then also add B2:G2 (instead of just B2:G2, as I am wanting). Is there a way to have the loop disregard those checkboxes that are already checked? Thank you for your time!!

  • @undertakerex111
    @undertakerex111 3 роки тому

    How to protect checkbox cells but still have them be toggle-able while sharing to anonymous?

  • @CrazyDaneGos
    @CrazyDaneGos 6 років тому

    Great video. Is it possible to make the checkboxes so only one can be checked? like you have 3 qustions and you can only select one, and if you click one of the other boxes it will move the check mark?

  • @myleetran7285
    @myleetran7285 5 років тому +1

    Can you do a checkbox where it will select/unselect all other check boxes?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  5 років тому +1

      Yes, but you'll have to use scripts for this.

    • @viyankariswanda9518
      @viyankariswanda9518 4 роки тому +1

      @@ExcelGoogleSheets is there tutorial for that?

    • @TheRangeControl
      @TheRangeControl 4 роки тому

      @@ExcelGoogleSheets can conditional formatting not make checking a box return false values to other checkboxes?

  • @radkostka
    @radkostka 6 років тому

    Awesome. Thank you.

  • @nj07013
    @nj07013 4 роки тому

    is it possible to create a 5x5 checkbox grid that will either eliminate checkbox(s) as a user checks the box(s), or instead of eliminate checkbox(s) place the users name into the place where the checkbox(s) and not allow additional users to select same box

  • @luiscorado2868
    @luiscorado2868 4 роки тому

    How can enable or disable this checkbox according to a formula or conditional formatting? Thanks in advance!!!

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 роки тому +1

      Just add a TRUE/FALSE formula in the cell. Check out IF function videos for more info;

    • @luiscorado2868
      @luiscorado2868 4 роки тому

      Thank you, you and all your videos are awesome!!!

  • @cvadim88
    @cvadim88 6 років тому

    Thank you very much!

  • @markoblanko8377
    @markoblanko8377 5 років тому

    Oh, man thank you! Subbed for sure.

  • @davidslaga4161
    @davidslaga4161 4 роки тому

    Thank you for the video - Can you check the 'check' symbol to, say, a number? Or create a watermark of a number behind the checkbox itself? Thank you!

  • @excelmylife1565
    @excelmylife1565 6 років тому

    Very useful sir

  • @muratilik2486
    @muratilik2486 6 років тому

    Hi i have some questions,
    Can i run macro with checkbox?Bu i write a cell =myFuction() then i take an eror " u dont have permission to call..... ". İf i draw a button and push it, macro works.
    i tell u my sheet. We are manufacturing machinery. And i want to save all step And i add checkbox in the sheet. My worker are clicking Checkbox and then i want to save time and other information. So i need run to macro when my worker are clicking checkbox

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  6 років тому

      you will need to use onEdit event function for this. If you watch my dependent dropdown data validation with apps script videos it should give you an idea how it works.

  • @omosteve
    @omosteve 2 роки тому

    Can you have multiple checkboxes in a cell ?

  • @neicymcfadden6232
    @neicymcfadden6232 4 роки тому

    If I wanted to add a cell value to a checkbox and get a sum of all True boxes how do I do that? You pretty much did that but the difference is; everytime you check a box it gives the sum of the regions. I just want one value for a check box. Sorry if that's confusing

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 роки тому +1

      use SUMIFS function

    • @taneicemcfadden3246
      @taneicemcfadden3246 4 роки тому

      Learn Google Spreadsheets I used that function. However, I’m having a hard time trying to finish the formula. There’s a number in Cell D3 that I would like to link to the Checkbox. If it’s True then I want the sum of all of the checked boxes. It’s pretty much what you did but my formula is missing something to link the checkbox to the number in Cell D3. I feel like I’m so close!

    • @taneicemcfadden3246
      @taneicemcfadden3246 4 роки тому

      Learn Google Spreadsheets if it’s possible, I’d like to share my sheet with you for guidance or clarification on what I’m trying to do.

    • @taneicemcfadden3246
      @taneicemcfadden3246 4 роки тому

      Learn Google Spreadsheets thanks for responding btw!

  • @gloriapotts9202
    @gloriapotts9202 3 роки тому

    Hi, is there a way to do a SUMSIF for words not values?

  • @fixfalcon979
    @fixfalcon979 5 років тому

    Thanks friend for your explanation.
    I would like to know how I can do so with only checkbox activate the other 40 checkbox.
    It is for attendance record control. I have a sheet of assistance signatures and I need to register them. For this I need to activate all 40 checkboxes in checked and disable or unchecked the missing students.
    How can I do it?
    Thanks in advance

  • @robinbartlett4547
    @robinbartlett4547 6 років тому

    Very good thanks,but when I email a check box it disappears and becomes true, false and checkbox does not work any advice ?

    • @ilmafarooq213
      @ilmafarooq213 4 роки тому

      Same.question here. Triuble getting others cclick and tick the ccheckbox

  • @ankuracharjee4184
    @ankuracharjee4184 3 роки тому

    How to add checkboxes in A:A automatically when a value is added in B:B???

    • @abayomivictor92
      @abayomivictor92 2 роки тому

      Lol this is what I have been looking for. If you have been able to get this please share with me. Thank you!

  • @vikasmange383
    @vikasmange383 5 років тому

    NOT WORKING WITH DIFFERENT TAB OF SAME SHEET.CONDITIONAL FORMATING SHOWS WARNING -INVALID FORMULA.

  • @abhiprit20
    @abhiprit20 6 років тому

    A quick question,hope you will response.
    How can i insert same comment for multiple cells at a time.?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  6 років тому

      I don't think you can do it within regular functionality of google sheets. It should be possible to do it with a script though.

  • @lazalazarevic6192
    @lazalazarevic6192 6 років тому

    Cool video

  • @mark-anthonygrant4495
    @mark-anthonygrant4495 6 років тому

    Is there a function that will auto check the checkbox?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  6 років тому +1

      Just create a logical test that will give you true and false and that should auto check /uncheck the box.

  • @mrchip8191
    @mrchip8191 4 роки тому

    I'm having an issue where if I reload my page all the checkboxes disappear and are replaced with their values true and false does anyone know how to fix this?

    • @ilmafarooq213
      @ilmafarooq213 4 роки тому

      Same question. Let me know if come to know the anseer.

  • @designerabysneha
    @designerabysneha 4 роки тому

    Thanks🙂

  • @philmijares
    @philmijares 3 роки тому

    Hi Sir. Need your help. How to automatically update a Google sheet whenever there's new entry from other sheets.
    Let's say Sheet A is the database, and Sheet B and C are the data source. Whenever someone updates Sheet B or C, it will automatically fill the next blank row in Sheet A.
    I hope I was able to explain myself. 😅
    Thank you in advance.

  • @suraj_m4656
    @suraj_m4656 5 років тому

    can you please make a video for filter by color in google sheet that will be very helpful for me and will be thankful.

  • @DarkMoonDroid
    @DarkMoonDroid 5 років тому

    15:49 To-Do Lists

  • @VirtuesOfSin
    @VirtuesOfSin 3 роки тому

    This is the video I wanted. Lol

  • @Muralmontage
    @Muralmontage 4 роки тому

    This is great! But! I would love to see this with just two locations from a blank sheet. This tutorial could be so much clearer if it were simplified and started from a blank sheet.

  • @BartFlossom
    @BartFlossom 6 років тому

    This is an area where Sheets is superior to Excel. Since Sheets does not treat the checkbox as an object, conditional formating becomes so much simpler.

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  6 років тому

      It's hot and miss. Some areas it's better, some it's worse.

  • @shantanudeyasi
    @shantanudeyasi 6 років тому

    NEED CHECK BOX AS OUT PUT

  • @ZetruH
    @ZetruH 2 роки тому

    I just wanted to add 1 to a cell when the checkbox was true, this is very complicated

  • @barathsarathy1066
    @barathsarathy1066 6 років тому

    Any one Please help me to create Sound Alert in Google Sheet

  • @cuneiformscript2665
    @cuneiformscript2665 4 роки тому

    🙏🏻

  • @2010Sheb
    @2010Sheb 4 роки тому

    How to configure the checkboxes so that when I select one of them the others are turned off? By type of radio buttons

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 роки тому

      Why not just use radio buttons?

    • @2010Sheb
      @2010Sheb 4 роки тому

      Learn Google Spreadsheets Will the radio buttons work in the table?

    • @ExcelGoogleSheets
      @ExcelGoogleSheets  4 роки тому

      @@2010Sheb They should.

    • @sgunter4691
      @sgunter4691 4 роки тому

      @@ExcelGoogleSheets How and where should I write that line? Thanks