Earlier this week Google announced that you can now insert checkboxes into Google Sheets. This means your many ideas for its use can begin. Wanting to see what an easy set up would look like I created a short attendance sheet with the checkboxes. Then, I discovered, by accident, that you can incorporate them into your formulas.
A checkbox that's been filled in shoes up as a 'True' value while a checkbox not marked is 'False'. Testing the CountIf formula I was able to get my formula to count how many times a student was in attendance or absent. Trying to think of other uses for the checkboxes to be used I came up with:
- Attendance
- Reading logs
- Chore lists/charts
- Material pick up/drop offs
- Clothing sizes for ordering
- Signing up for days/times
- ETC.
By using the checkboxes in a formula, you could then put your information into a pivot table or chart. Let your imagination go and think of how this could be useful to you. If you think of any others ways to use them please, share them with us. We'd love to hear them
Beth
Comments
Post a Comment