Checkbox or Dropdown?

Checkboxes vs Dropdowns for Attendance, Status, and Counting This episode compares using checkboxes versus dropdown menus in Google Sheets for tracking attendance and other statuses. It shows how a checkbox is a single yes/no action with no null state, while a dropdown can include a third blank option and additional reasons (e.g., busy, another event) and can be color-coded. You’ll learn how to count checkbox selections with COUNTIF, how changing checkbox custom values (e.g., checked = “attending”) affects formulas, and how to update counting to match the new values. The video also covers using a separate notes/reason column alongside checkboxes, using dropdowns for CRM-style outreach workflows with multiple statuses and blanks, and enabling multiple selections in dropdowns to combine roles like volunteer and speaker in one cell. 00:00 Checkboxes vs Dropdowns 00:51 Counting Checkbox Responses 01:35 Custom Checkbox Values 02:45 Dropdowns for More Detail 03:40 Checkbox Plus Notes Workflow 04:37 Choosing the Right Option 05:10 CRM Statuses and Multi Select 06:28 Wrap Up and Next Videos