Thursday, May 3, 2018

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,