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 t...