If you want a way to choose yes/no in Google Sheets, using a checkmark can be a good way to do it. While it is not a built-in function, there is a way to create a checkbox drop-down in Google Sheets as shown in this linked Google Sheet. The method is a bit of a workaround, but it does end up giving you a drop-down with the option of a box with a checkmark in it or a blank box. Keep in mind that some newer spreadsheet programs have a built-in drop-down data type. The steps below will get you there quickly.
Video explanation
Note that this video discusses both dropdowns and checkboxes.
First Step – Data Validation
Click on the Data menu option and then Data Validation.
Once the Data validation window pops up, choose List of items from the criteria drop-down box.
Pick from a few different symbols
Copy and paste the two checkmark symbols below. These will be the two options that show in the drop-down list. If you would like other symbols, they can be found by using Insert Special Characters option in Google Docs and copy and pasting them back into Sheets. Below are two easy, intuitive symbols.
?,?
Following are more options you can use. Note that you can have the user click a checkmark for yes, and just leave the drop-down empty for no if you want to just use a checkmark not the empty box.
⌧☑✅✓✔???
End result
Keep the rest of the options at their defaults and choose save. You now have a check box!
