I WANT A SCRIPT WHICH IS WORKING AS REQUIRED LIKE , IF COLUMN K CELL VALUE IS DONE THEN P COLUMN CELL SHOULD BE UNPROTECT OTHER PROTECT

I WANT A SCRIPT WHICH IS WORKING AS REQUIRED LIKE , IF COLLUMN K CELL VALUE IS DONE THEN P COLLUM CELL SHOULD BE UNPROTECT OTHER PROTECT

I am working on filtering a google sheet for data and creating time series charts off of it with each athlete as a different series on the graph. The graph is being created properly but I cannot figure out how to set the legend labels on the graph using the built in functions.

I have a Looker Studio custom connector written in Google AppsScript. In the connector, I am using the LockService’s tryLock(), hasLock(), and releaseLock() functions to prevent concurrent execution of a section of code. Most of the time it works fine, but sometimes I get an error like this:

I have installed the myTime script to detail the events on the Google Calendar. I will have multiple reoccuring events that need to be detailed individually. At the moment, the myTime script will only detail one event of the infinite reoccuring events. How can I change the script in order for it to detail each events as a seperate row of data?

I have created a gmail addon which gives user a quote of the day as signature.Addon shows a list of quotes and each quote has a toggle button below it. Use can toggle the button if he doesn’t not want the quote say for today to appear in compose box.But the problem is if user turnoff toggle for quote say for today then in compose box the signature still appears and I have to manually refresht he gmail tab to reflect the changes.

I have been working on a Google Sheet linked to a Google Form. I created a app script and tested it to work fine. Then I closed the App script editor and cannot get it to open again. Everytime I try to invoke the App script editor it gives me a 500 error.

I am unsure of how to write this script and wanted to know if one already exists I have written IF formulas that analyze a given row for the presence of the string and sum the values, but that is not working as I want it to be dynamic, triggered based on form submissions, analyzing […]

I’m working on a Google Apps Script that interacts with the Canvas Data 2 API and Google Cloud Storage. The script retrieves data from the API, processes it, and uploads it to Google Cloud Storage, eventually loading it into BigQuery.

I have created a pair of Apps Sheet files which run fine for me. I have shared the Google Sheets with other users. But those users cannot execute the scripts. How do I give them permission?