Skip to main content

Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
-1 votes
0 answers
14 views

Automatically remove duplicates based upon semi reused Unique Numbers and date leaving the latest dated items

I suppose you hear this all the time but here I go again "I'm new to Google Sheets" :-) Apologies for asking what might be basic questions! So, I have a google sheet that is populated by a ...
Clever Dog Production's user avatar
-1 votes
0 answers
6 views

Trying to Countif Color of Cell matches

I'm currently using the following code: function countColoredCells(countRange,colorRef) { var activeRange = SpreadsheetApp.getActiveRange(); var activeSheet = SpreadsheetApp.getActiveSheet(); ...
Stephanie Keffton's user avatar
-1 votes
0 answers
12 views

Need change Google Sheets to Google Drive Script to make sure the downloaded image has an extension included

This is a script I created using ChatGPT and it works but there is a small issue. The script checks a column called "downimg" to see if it contains the text "stop", if it does, the ...
itoldusoandso's user avatar
1 vote
1 answer
13 views

Will Google Transfer for Education Save my Container-bound Apps Script Files?

I am a teacher and am leaving my school district soon. I have created a large number of container-bound scripts in Google Sheets, Docs and Slides files. I want to take these with me, but when I tried ...
Phil Anderson's user avatar
-1 votes
1 answer
18 views

How to get a cell to autodelete contents after subtracting from another cell

I have a spreadsheet to keep track of payments on group trips and would like to be able to keep everything within that spreadsheet. I would like the ability to be able to delete from the sum that ...
Yager's user avatar
  • 1
0 votes
1 answer
21 views

Getting error thrown when trying to retrieve a png in my own google drive using UrlFetchApp.fetch()

I have a script running that creates a qr code for a google form and saves it to my google drive and collects its url. I'm trying to then put that qr code in a google doc. I could have sworn my code ...
AnonymousTurtle's user avatar
0 votes
1 answer
30 views

Macro to return 1 + the value of the cell above

I am experienced with VBA but not Google Apps Script / Javascript. I'm doing a lot of data entry for which filling down with CTRL+D is super-useful but I want to create a macro that will copy down the ...
Daniel Austin's user avatar
1 vote
2 answers
50 views

Replace text in document using A1 notation as variable names in order to retrieve values stored in those cell references

I have a Google Doc that contains placeholders based on A1 notation like %A1%, %B3%, %A3%, and so on. In a Google Sheet I have values stored in the cell references that match the variable names. I ...
user61681's user avatar
  • 113
0 votes
0 answers
16 views

How to correct script which get emails of users? [duplicate]

I try to get eMails of users which change any range in my Google Sheets. I use this script below: function onEdit(event) { var as = event.source.getActiveSheet();//Текущий лист var address = event....
Group Stroy's user avatar
-1 votes
1 answer
37 views

Get list of files from Google drive into google sheets based on date range using app scripts

Hello I am looking for a script to get list of files from google drive within a specific date range. I have got a script on this site here: List new files from a specific Drive folder and subfolders ...
Shah Ankit's user avatar
1 vote
2 answers
43 views

Printing the date of a cell in the Google Apps Script console

I wrote in cell D1 the function "=today()", and in google apps script I'm trying to print it in this way: function myFunction() { const ss = SpreadsheetApp.getActive(); const ws = ss....
Federica Guidotti's user avatar
2 votes
1 answer
23 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
-2 votes
1 answer
22 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
54 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
8 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 votes
2 answers
44 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
79 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
76 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
79 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
1 vote
1 answer
36 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
36 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
39 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
143 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
22 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
30 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
43 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
36 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
143 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
29 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
112 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
161 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
55 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
25 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
18 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
95 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
166 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
101 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
32 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
124 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
124 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
86 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
57 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
1k 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
632 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
55 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
80 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
28 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

1
2 3 4 5
37