Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
2 votes
1 answer
20 views

How can I use multiple values to create sheet names when using a script to create multiple sheets from master sheet?

I have a list of students assigned to various test rooms, and each room has a different test. (Although there are duplicates.) I would like to create a separate sheet for each test room where the name ...
Myles Leggette's user avatar
0 votes
0 answers
11 views

How to speed up Google Sheets Apps Script [migrated]

Here's my apps-script: function doGet(e) { return ContentService.createTextOutput("POST request processed successfully!").setMimeType(ContentService.MimeType.TEXT); } function doPost(e) {...
Somanna M S's user avatar
-2 votes
1 answer
21 views

Any idea why I am getting duplicated cells in google sheets?

Hi there can anyone tell me why am getting a duplicate on the following code in cell c3 I am getting this anytime a new form was added function onEdit(e) { // Get information about the edited cell ...
Omar's user avatar
  • 1
0 votes
1 answer
30 views

Apps script cannot find Google Sheet

I set up a simple script to download a CSV into a Google Sheet. I saved the code, gave permissions on running, ran it from the script editor associated with the correct sheet, double and triple ...
Drewbot's user avatar
0 votes
0 answers
7 views

Need Help to split text to a row using App script [duplicate]

I made a daily student attendance app using Kodular and a spreadsheet as a database. I connected the kodular to a spreadsheet using Appscript. The app worked well, but since I'm a newbie in app script ...
Mr Irsan's user avatar
1 vote
0 answers
14 views

How to split text to a row using appscript? [migrated]

I made a daily student attendance app using Kodular and a spreadsheet as a database. I connected the kodular to a spreadsheet using Appscript. The app worked well, but since I'm a newbie in app script ...
Mr Irsan's user avatar
-1 votes
2 answers
41 views

Changing text styles within parentheses (partial cell values)

I'm trying to write a Google Apps Script to italicize any text in parentheses in a specified range in Google Sheets (partial cell formatting). Ideally it would also remove any existing text-only ...
gills's user avatar
  • 192
0 votes
2 answers
77 views

Formatting dates based on year

I'd like to create a Google Apps Script that changes the format of all dates in a sheet based on the year. If the date is in the current year, the format should be, e.g., Aug 5 If it's in an earlier ...
gills's user avatar
  • 192
1 vote
1 answer
47 views

Recorded a Macro to Import a File in Google Sheets

I'm able to import a file from my disk using "File Import". I tried to do the process while recording a macro. I did "File", "Import", then chose "Upload new file&...
NealWalters's user avatar
1 vote
1 answer
36 views

How to copy and paste by using apps script, to the bottom of a list, where the bottom will change after every paste?

I have a system set up in Google Sheets that, from an input produces an output in 'Mover'!K2:V, and that output has to be copied and pasted 'values only' to the bottom of a list on another sheet '...
BMAli's user avatar
  • 19
0 votes
1 answer
28 views

Modification of the Google Sheet script for email notifications

I use the code from this answer in my file: https://webapps.stackexchange.com/a/149424/316384 Can someone help me modify it so that the script sends an email when the value changes to the one I set? ...
robisy's user avatar
  • 27
1 vote
1 answer
32 views

How to stop + and - from generating formulas using Apps Script Google Sheets?

My Problem I have a column of data for users to input text, and it is highly expected that they should add a plus or minus before text, which would result in an error. For example, they are often ...
Cameron Schwarz's user avatar
-1 votes
1 answer
32 views

Google Form validation from a Google Sheet for Inventory

I'm trying to make an inventory system and am struggling with using a Google form to check out inventory. I would like the form to validate that the products being removed from inventory are actually ...
Lucasheythere's user avatar
2 votes
1 answer
38 views

Preventing different users from viewing other sheets using Apps Script

How to prevent users from viewing other sheets using Apps Script I have 3 sheets Tom Jack Mark I want Tom should see only Tom Sheet I want Jack should see only Jack Sheet I want Mark should see ...
Prasad K's user avatar
-1 votes
3 answers
81 views

Script to change specify text style within Google Sheet's cells, but I cant seem to style text manually

I have a script in Google Sheets that automatically finds and formats specific text substrings within a cell that I edit. A side effect of using the script is that it will reapply the existing cell ...
Padang's user avatar
  • 1
1 vote
1 answer
19 views

Script successfully copies sheet contents to Gmail but doesn't include formatting

I've set up a Google spreadsheet so that it creates a new draft message in Gmail and copies the contents of a sheet into it. However, when the sheet contents are copied over, it only copies the ...
Evan Ballard's user avatar
0 votes
1 answer
29 views

cell values are the same but got FALSE when check them

I have this sheet : Formula A1 : =text(today(), "DD MM YYYY") Formula B1 : =text(today(), "DD MMM YYYY") Formula A4 (check if A1 = A2) : =A1=A2 Formula B4 (check if B1 = B2) : =...
andio's user avatar
  • 397
0 votes
1 answer
35 views

How to force reloading custom function result? [duplicate]

I use this script to get the current sheet name : function sheetName() { return SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName(); } then use =sheetName() in the cell to load the ...
andio's user avatar
  • 397
0 votes
0 answers
19 views

How can I make a script to change the text color in google docs? [duplicate]

I don't have an example to give because I couldn't find one. But I tried using Google Apps Scripts to make a script to change the text color of a highlighted text. It ended up selecting the whole ...
Cone Mations's user avatar
0 votes
1 answer
114 views

Change tab color based on cell vaule

I am trying to change the tab color based on a cell value on an individual sheet. I have multiple tabs. The cell value that will determine whether or not it gets a color is a cell containing a date. ...
Vikki DeFilippo's user avatar
1 vote
1 answer
22 views

Prevent edits to an Apps Script project bound to a Google Sheet [duplicate]

I have a google sheet where I require users to edit certain cells with all other cells locked and with a tick to reset script button, but I would like to know if its possible to lock the script from ...
DZDU's user avatar
  • 11
1 vote
1 answer
57 views

How to use Google Script to email a pdf of just one sheet (tab) within a spreadsheet/

I have located some similar posts but none of the solutions seemed to work. I have a function that sends me an email PDF of a spreadsheet. I just want the email attachment to send the first sheet (tab)...
Darren's user avatar
  • 11
0 votes
1 answer
111 views

Freeze the value of a cell when using a formula and external (volatile) variables

Apologies if the title question is unclear, please feel free to suggest any better wordings of it. I'd like to know if there is any sort of system in place where I can "freeze" the value in ...
Sander's user avatar
  • 3
0 votes
1 answer
49 views

onEdit trigger causes updated date to be returned as a number

I currently have a Google script bound to my spreadsheet using an onEdit trigger to allow multiple dropdowns. However, it is affecting my columns with dates, changing them from date format "DD/MM/...
Harry W's user avatar
0 votes
1 answer
23 views

Does running clasp scripts require a paid setup for the Google Cloud Platform?

I am to run Google Apps scripts from the command line with clasp. I had a problem, and at https://github.com/google/clasp/issues/506 I was instructed to Inside browser Click Resources -> Cloud ...
Gergely's user avatar
  • 153
1 vote
1 answer
26 views

How do I get this to function on multiple sheets in a workbook?

I'm still fairly new to Apps Script. I found this answer several months ago and it's been working great, but I've been asked to implement it on several sheets in a workbook instead of just the initial ...
Phillip Shurtleff's user avatar
-1 votes
1 answer
17 views

Google app script not doing everything I want

The script i wrote is below. However it is putting the data on sheet tracking and moving down to row 21 instead of 2 and then keeps overwriting 21 instead of moving to 3 then 4. Can someone help me ...
Brian Roberts's user avatar
0 votes
2 answers
84 views

Custom function to move and delete a row isn't doing anything

I have a script bound to my Google spreadsheet with a simple onEdit(e) trigger that isn't working. The script is supposed to move the edited row to Closed Cases, then delete the original row, if the ...
Kelly's user avatar
  • 1
0 votes
1 answer
91 views

Determine if onEdit() was triggered by inserting or removing a row

I have two spreadsheets, SS1 and SS2. I need to update SS2 when a row is inserted into or removed from SS1, or when a certain range of cells is changed in SS1. I use an installed onChange() trigger to ...
Marshall Morrise's user avatar
1 vote
1 answer
26 views

Trigger script to share calender with new user whenever form updates sheet with a new email address

I have a Google form that allows people to submit their name and email address in order to sign up for a private shared calendar. The form populates a Google sheet. I want to automatically add new ...
knawhatimean's user avatar
2 votes
2 answers
80 views

How to do autoresizecolumns() in a Google Sheets file when data imported from another Google Sheets file is changed

I'm new to Google Sheets and apps scripts. This is my first ever question. I apologize in advance if I don't get it quite right. Google Sheets file Staff Roster sheet Roster contains names, contact ...
Marshall Morrise's user avatar
1 vote
0 answers
29 views

Insert a new row in Sheet 2 for each cell in a range in Sheet 1 that is not empty [closed]

Hi I'm new to the Google Sheets App Script and not sure where to start. I'm trying to write a Script that will insert a new row in Sheet 2 for each cell in a range in Sheet 1 that is not empty. For ...
newbie's user avatar
  • 11
1 vote
2 answers
113 views

Two custom fnctions triggered by OnEdit both returning errors

I have two custom functions bound to a Google spreadsheet with an onEdit() simple trigger that are returning errors. The first function sortStatus() sorts the columns in range A2:R by I2:I (col 9) ...
rellawp's user avatar
  • 13
1 vote
1 answer
86 views

Format a numbered list in google docs into a table template?

I have a list with a url, an emoji (of a set of 3), and a name in a numbered list. Taking a list like this: https://news.ycombinator.com/item?id=38122061 🥾 D. onohoe https://news.ycombinator.com/...
Havok's user avatar
  • 11
1 vote
1 answer
78 views

Timestamp on change of another range

I have a Planning sheet that I use to follow budgets that are reported every week. I'd like to have K7:18 stamped with a date when there is a change in the corresponding cell of I7:I18 range. I cannot ...
user318609's user avatar
0 votes
0 answers
41 views

Putting a custom function in same file as Apps Scripts [duplicate]

I'm sure I'm missing something very simple, but here is my problem. I have a spreadsheet with an apps script that has global variables that require authorization (due to openBy). I want to add a ...
E.B. Sandberg's user avatar
0 votes
1 answer
862 views

I am using Google App Scripts SpreadSheet.openById(), but it assumes Sheet0 as active sheet?

I am trying to create a trigger to get id when there is a change in sheet selection which is working fine when each google sheet has its own google app script, but I want to create a google app script ...
Zaid Bhimala's user avatar
1 vote
1 answer
428 views

SpreadsheetApp.openById gives unauthorised error

I am trying to trigger a function in Google Apps Scripts, and am using openById("Sheet_Id); But on using it, I am getting this error: Exception: You do not have permission to call SpreadsheetApp....
Zaid Bhimala's user avatar
-1 votes
2 answers
52 views

Google Apps Script for gradebook sharing: Create duplicates of current sheet, one per row of data, with importrange of the source and header rows

The goal is to create a workaround to the typical problem of not having per-row privileges. I want students to only see their row of the grading document. Typical solution is to share another sheet ...
whatsnewsisyphus's user avatar
1 vote
1 answer
73 views

Adding (and updating) time stamp when cell color is changed in Google Sheets

I'm very new to scripts so please bear with me. I want to make a condition where if a cell color is changed, a new timestamp is created. So a cell will start from white (unused) and change to ~3 ...
David Yang's user avatar
0 votes
1 answer
27 views

Google Sheets complex formula or script is needed

I have trouble with creating a complex conditional formula in Google Sheets. Honestly, I feel there is a need for some script with a "for" cycle, but I'm not sure. The task is the following. ...
Alex Savin's user avatar
1 vote
1 answer
25 views

onEdit updates correctly, but then overwrites following columns after pasting (editing) multiple rows

I'm using Google Spreadsheets and found a script here: onEdit only updates top row after pasting (editing) multiple rows I manipulated the script to fit my needs, and I need it to only look at column ...
Jan's user avatar
  • 13
0 votes
1 answer
329 views

Change cell color if data is changed from "initial value" in Google Sheets?

How can I architect a system where a customer is given a spreadsheet with 1000 rows / 5-columns each of data, and if they edit any cell, it gets highlighted blue? Probably doing this using App scripts ...
Lance's user avatar
  • 277
1 vote
0 answers
25 views

How can I get email notifications for changed cells, including what changed and context from some nearby cells? [closed]

I would like to receive help in modifying the scripts in Email notification when any cell in specific column is changed. Based on previous code, how can I make the email content include not only the ...
robisy's user avatar
  • 27
1 vote
0 answers
20 views

Google Sheets: Change text color of cells in other columns if specific cell is focused?

I have a sheet with four columns. What I would like to do is the following: If the cursor is inside a cell in column A (meaning that cell is focused), the cells of that row from the other three ...
orschiro's user avatar
  • 5,498
0 votes
1 answer
24 views

Failure to autsort Google Sheets

I have a Google sheets that has the responses from a Google Form. I want the responses to be sorted according to contents of three columns (9, 12 and 13) when the sheet is opened. I'm using this ...
To Do's user avatar
  • 135
1 vote
0 answers
13 views

Update Google slide training suite using scripts [closed]

I have a series of Google slide decks which form a training pathway and we need to update them asap but don't have a lot of time for donkey work. Our brand colours have recently updated and I would ...
Emily Symington's user avatar
1 vote
1 answer
127 views

How can I Speed up an onEdit script so that it captures all subsequent edits?

I have a bit of script to capture changes made to a table of information, pulling the new value as well as the person's ID, a category, and the reference of the item being changed. Altogether the ...
Roli Payne's user avatar
2 votes
1 answer
73 views

How do I modify my script to unhide all sheets subject to multiple exceptions? [closed]

How would I modify this script to make multiple exceptions not just for one sheet? I am trying to unhide all sheets except for a few not just for one sheet. function main(){ activateAllSheetsExcept(...
Dominique Wren's user avatar
1 vote
1 answer
102 views

Locate a text string and return the width of the range containing it based on whether it's in a single or merged cell

I have calendar data in my spreadsheet. Each row is a day, and each column is a half-hour increment of time from that day. When I add events to the calendar I block off the time by merging the ...
Gianluca's user avatar

1
2 3 4 5
37