python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - google-sheets

Retrieve answers from a checkbox grid of a Google Form with Google Apps Script

I'm trying to store the data of a Google Form into a Google Sheet. In the Google Form there's a checkbox grid that contains a list of questions. I want to get the values (the answers) of the checkbox ...
test-img

Angélica Castillo

google-apps-script

google-sheets

google-forms

Votes: 0

Answers: 1

Latest Answer

Instead of including yourVariable  as an element of array use JSON.stringify(yourVariable). From https://developers.google.com/apps-script/reference/forms/checkbox-grid-item For CheckboxGridItem que...
test-img

Rubén - People First

How can I turn this regex formula into an array?

I have a regex function for a column in Google sheets which is something like below: =REGEXEXTRACT(E2,"\Q"&REGEXREPLACE(E2,"\w\S*@\S+\w","\\E(.*)\\Q")&"\E&qu...
test-img

Utkarsh Maheshwari

javascript

arrays

google-sheets

Votes: 0

Answers: 1

Latest Answer

Keep in mind that we can't see your spreadsheet. We don't know your data or what you are trying to do. That said, you have to start by marking the formula as an array formula by wrapping it in ArrayFo...
test-img

Erik Tyler

Categorise a Column Of Text Strings Using a List in Another Column - Google Sheets

I have a column with text strings in and I would like to categorise them according to a keyword in that string. For example, in column A: i use php i use java i uses angular i used javascript And in...
test-img

MartinBig

google-sheets

Votes: 0

Answers: 1

Latest Answer

try: =INDEX(IFNA(VLOOKUP(REGEXEXTRACT(A2:A, TEXTJOIN("|", 1, C2:C)), {C:C, B:B}, 2, 0)))
test-img

player0

Apps Script: Batch Create Calendar Events without Creating Duplicates

I'm working on a script that takes a list of tasks from Google Sheets and automatically creates events on Google Calendars, putting the event on the Calendar of the team member to whom the task is app...
test-img

dylan-bush

javascript

google-apps-script

google-sheets

google-calendar-api

Votes: 0

Answers: 1

Latest Answer

In your situation, how about the following modification? Modified script 1: In this sample script, the value of X is put in the "Scheduled" column. function scheduleTasks() { var spreadshe...
test-img

Tanaike

Posts

Questions

Blogs

Jobs