Customize values to your checkboxes in Google Sheets

Today I was asked a question on YouTube dealing with checkboxes in Google Docs and how to get a sum of the total number of checkboxes. Here is how to do it.

• Enter into your Google Sheet and select the area that you would like checkboxes to appear
• Select Data
• Data Validation
• Criteria - select the box that states select from range and change the criteria to checkbox
• Select use custom cell values (for this example I used 1 for checked and 0 for unchecked)
• Select Save
• Go back to the sheet and select the boxes you would like checked
• Finally, insert a Function (in this case I used sum)

Embedded below is a 1 minute and 9 second YouTube tutorial I created.

Take care,

Brad