Google Sheets Checkboxes

A video based on the tutorial from @aprimarykindoflife. You can use these checkbox features to mark attendance, participation, and completion tasks! Check out her Instagram for even more ideas!

[@Kurono98]

Thank you very much, this is exactly what I was looking for, I searched this topic on my language on youtube for help but everything was meaningless until I saw your video. Wishing you a lot of health. Love you from Vietnam ❤

[@iugen1398]

This was super helpful, thank you!!

[@ghita2374]

Thank you. You explain so well. ❤❤❤

[@raksmeyax4497]

Thanks! I finally found it!

[@starry.night7]

loved it! thanks for sharing :)

[@GreenedBeens]

Thanks so much. I was so confused by this!

[@jeffersonandrade_]

Muito obrigado, você me ajudou demais! 👍🏼👍🏼

[@lienphan6446]

Thank you very much!

[@courtneyberry3693]

THANK YOU!

[@rioreinalabramonte7257]

what do you need to do before highlighting the cells so the values will appear on the column or row that you chose?

[@hectorsalvadorgarciaromo9104]

Easy, Thanks a lot.

[@Tech_With_Bilal]

Thank you so much

[@learningstuff5679]

Thank you.

[@mahmoudmmahmod2592]

Thank you very much for this guide, I just want to know if there is any way that I can percentage of progress without numbers? for example, I want to track mission progress, not including any numbers just texts.

[@meenakshishadija6758]

Are the sample softs there when you open the software or do you have to download them from sowhere

[@Teamenthusiastic-qe5wq]

Thank You Ver Much. Wishing you a lot of health. Love you from Bangladesh

[@tottieferrufino]

Hi can you explain me how you did the student column please? I cant find it anywhere :(

[@jorikaish]

I want make chose only one checkbox between 6 , I transferred xlsx file from Excel to sheets checkboxes are missing and now I add it manuall but can’t check one and uncheck other

[@ProfitDoctor]

Great layout :-)
if I wanted to have it count to four (false/1/2/3/4) instead of 1 (false/true) how could I do that? I like that for a habit tracker the checkbox is easy for a mobile device but instead of say “drink a lot of water” or little/no water, could I use it to count glasses of water (Eg 1/2/3/4 glasses). Essentially a counter vs opening the cell and inputting a number.

[@Emmie1223]

A counter? You could add the sum with the data validation then the conditional formatting to change the colors c: if you want at least. But then when you take the data validation, take the numbers (by highlighting all the checkboxes) then dividing by how how many you want.
Or if you want it to be more extra, you could add the sum (like the video) then dividing to get the percentage. But if you just want the sum you could get it :)

[@dustonmeyer3770]

ok having a problem I set checkbox value to 5 I have a checkbox in columns c,d,e,f I can change the color of column a by setting range to a and using =C1=5 then turn it red, that works I can do the same for d,e, and f and change the color to what ever I want. How do I add column c+d to make column A a different color so C1=5 is red and C1+D1=10 turns the red to a different color I want Column A to change color every time I click the checkbox when more then 1 box is checked it changes again

[@fadovadio5293]

Thanks for the video. Can yu show how to transfer value of checkbox to another sheet. (like marking payments on a client?) Thanks

[@timelesstimesgoneby]

So I’m trying to make it change only when there’s new info checked and color it differently time stamp but everything I have tried to do changes the date even when there’s no new total check boxes

[@fadolamicht-praise6434]

Nice one

[@karlal9609]

such a helpful video, thank you! but for the color formatting, mine doesn’t change to red or yellow when i tried unchecking boxes. it just stays green even if it’s at 0% 😢

[@ashystarz694]

Me neither :( not sure how to get it to work

[@ssccglwithgenaram9423]

Hello mam please send me formulas link for that type of spark line bar

[@brookewright7653]

Can the students see just their data?

[@paulwyleciol3459]

oh my gosh, is that girl sweet ... !!!!!

[@Fawaz0.5]

شكرا شكرا شكرا شكرا اتمنى لكِ حياة سعيدة