¿Cómo inserto un botón de opción en Google Sheets?

How do I insert a radio button in Google Sheets?

To create your own radio buttons in Google Sheets, add this code to your Sheet:

1. Go to Tools > Script editor…
2. Delete the existing myFunction() code.
3. Copy in the code below.
4. Select the onEdit function and run from within the Apps Script editor to authorize the script.
5. Return to your Sheet to use the radio buttons.

If a submit button doesn’t appear at the end of a form, it usually means that there are some required fields that are unanswered and that the ‘X Questions to Go’ counter is active on your form. You might like to remove the X Questions to Go counter as this will show the submit button immediately.

Choose where to save form responses

1. Open a form in Google Forms.
2. In the top left under “Responses,” click Summary.
3. In the top right, click More. Select response destination.
4. Choose an option: Create a new spreadsheet: Creates a spreadsheet for responses in Google Sheets.
5. Click Create or Select.

Since Google Sheets does not support radio buttons, we used checkboxes instead and used Apps Script to ensure that only a single checkbox in a column can be checked.

The ability to insert radio buttons currently isn’t available in Docs. You might try using Google Forms (forms.google.com) instead of Docs, as it seems it might be better suited for what you’re trying to do.

Steps to try first

1. Refresh the page. If you can’t open or edit a file, try to refresh the page.
2. Open your file in a different browser.
3. Check how the file is shared.
4. Check the format of the file.
5. Try a smaller file.
6. Turn off browser plugins and extensions.
7. Clear cache and cookies.
8. Turn offline settings off and on again.

If you use Google apps through work or school, make sure you’re signed in to the correct account. When someone makes a form through work or school, only people in their organization can see the form. Unless they change that setting, these forms can’t be viewed from a Gmail account. Go to myaccount.google.com.

The only way to recover the responses if you previously set your form to send the responses to a Google spreadsheet, if you didn’t that before deleting the questions it’s not posible to recover the responses.

You add a button via the Insert > Drawing menu. When you click Save and Close, this drawing gets added to your Google Sheet. You can click on it to resize it or drag it around to reposition it.

As you can see in the GIF, the tool adds a date to the final “Status” column of my Google Sheet, indicating that the reply email has been sent. So how do we build this? This step is pretty straightforward.

1 User submits Google Forms survey 2 Response logged in Google Sheet 3 Google Apps Script parses responses and sends emails 4 Original user receives reply!

Lines 85 – 97 is the function we call to actually send the email using GmailApp service. Apps Script quotas will permit you to send up 100 emails/day on the free consumer plan. If you have more respondents than that in your Sheet, the program will stop where it is, and give you the following error message: