Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I know there's no checkbox functionality in a Google Docs spreadsheet but I was wondering if there's a way to get equivalent functionality somehow. What I'm looking for is a one click enable/disable or toggle in some form.

The closest I've come is manually editing a cell to enter a 0 or 1 but I'm hoping there's a nicer pattern.

share|improve this question

2 Answers 2

The best checkbox solution I've seen so far is the one used in this template (Here's a public document created by the template that you can view without logging in to Google Drive).

They have two cells in an extra sheet with a character or image of an unselected checkbox and one of a selected checkbox. Then in the cell where you want to use the checkbox, set the data validation to "Items from a list" and "Create list from range" and select the two cells with the characters/images. You then get a dropdown in that cell where you can select either option.

This doesn't provide the one click on/off toggle, but it's pretty close.

share|improve this answer
    
@JacobJanTuinstra , Looks like you need to be signed in to Google Drive to view the template. Here's a public document created by the template. –  Matthijs Wessels Mar 6 '13 at 15:46
    
@JacobJanTuinstra agreed –  Matthijs Wessels Mar 6 '13 at 16:02
up vote 4 down vote accepted

Yes, it is possible. http://code.google.com/googleapps/appsscript/articles/bracket_maker.html has a good sample, including how to add a button to a spreadsheet to run some Google Apps Script in Section 4. This can then be used to write the 0/1 to a hidden cell.

share|improve this answer
2  
Doesn't this approach only allow you to add buttons to the menu? –  Matthijs Wessels Mar 6 '13 at 12:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.