Questions tagged [google-apps-script]

For questions about using Google Apps Script to extend Google applications

Filter by
Sorted by
Tagged with
1 vote
1 answer
25 views

Function to create a calendar for one year with gaps (date and days in separate cells)

Is it possible to have a function within a Google Docs spreadsheet which I can link to a button which will create a calendar in the following format: Number will be 1 - 365 for the days Date will be ...
0 votes
1 answer
2k views

Auto insert Formula on the next empty row upon form submit

I have a spreadsheet that contains 3 columns with leave request data coming from a google form. [From Date] [To Date] [Name of the Requestor] 5/16/2018 5/18/2018 John 5/18/2018 5/20/...
0 votes
1 answer
29 views

Google Workspace Marketplace only shows first 100 sheets add-ons

When I select "Works with Sheets" on Google Workspace Marketplace, it only shows exactly 100 add-ons. I do not see any "More" button or any other way to see other than these 100. I ...
0 votes
1 answer
121 views

Trying to search(from sheet1 ) for a value on in any row of sheet2

I have 2 sheets "Main" and "Data Storage" Main: should allow me to search "Data Storage" and locate information form any column(let say Column B') and provide me with ...
0 votes
0 answers
14 views

Script that adds a row with formulas from previous columns while also sorting

I have a script that I enter B2, B5, E2, & E5 that will add it to the bottom row of the list. I'm needing to add the formulas that are all different from columns E:Y along with it and be able to ...
0 votes
1 answer
2k views

Pasting timestamp for edits by multiple users in Google Sheets

I got a good Google Sheet script for pasting a time stamp at the designated column of the same row on editing any cells of another particular column. Here it is On Edit of column 11: timestamp is to ...
0 votes
1 answer
648 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
0 votes
1 answer
15 views

Help adding checkbox to google sheets

I am a novice to google app scripts. However I need to copy selected rows (with a checkbox) to a second sheet. I am using this code below. However it copies the entire source sheet. I only need rows ...
3 votes
1 answer
2k views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
0 votes
2 answers
530 views

How to export CSV without commas in unpopulated cells?

I have a form converter which simply rearranges columns. I use a script to paste Values only into another sheet for export and uploading onto another website. However, when I go to export, it seems ...
0 votes
0 answers
6 views

I am trying to send multiple .pdf attachments stored in a drive folder, but this script only attaches the last file [duplicate]

function myFunction() { var html_body = "Estimados ¡Buen día! " + "<br/><br/>" + "Gusto en saludarles, agradezco su apoyo ...
0 votes
1 answer
32 views

Google sheets -How to modify a number in a formula based on user input

I was trying to automate a project where I would need to modify a number in one of the formula every time as per the user input. For example: in the above formula, the highlighted number (9) should ...
0 votes
1 answer
557 views

Google Apps Script to automatically send email

I am trying to create a Google Apps Script that will send an email to our client's general inbox when we receive an email from one of their representatives containing an order. We are required by our ...
0 votes
1 answer
377 views

Add row to Google Sheets and keep formulas from previous row

I want to add a row to my spreadsheet but keep the formulas – and only the formulas – of the previous row. The #1 solution provided here doesn't help me because it also copies non-formula information, ...
0 votes
1 answer
650 views

Move rows on 2 sheets older than 24 hours to archive

I have been trying to figure this one out for a while now and would really appreciate some assistance. I have a Google Sheet that is being updated by a Google Form. Due to this I needed to mirror the ...
0 votes
1 answer
17 views

Set value if condition is met

I'm trying to create a script which will do the following: Check if the number in col. B for each row is > 4 If it is: send an email & mark the associated cell in col. C as "Yes" e....
0 votes
1 answer
19 views

Cannot read property '0' of undefined at onFormSubmit

I have created a Google Apps script from a Google Sheet. Data is submitted to the sheet via a form. I had onFormSubmit(e) working fine and sending a custom email to the form respondent. But now it's ...
0 votes
1 answer
46 views

I am trying to find a custom function to find the min value of coloured cells ONLY for a range where some cells have a specific color

I am trying to find a custom function to find the min value of coloured cells ONLY for a range where some cells have a specific color. The best I could find is to count the cells with a certain color. ...
0 votes
1 answer
31 views

Copy variable Range (fixed number of columns, flexible number of rows based off cell value) to last row of another tab in the same sheet

I'm new to google script. I need to get a flexible range copied from one tab in a sheet to last empty row in another sheet. Flexible Range is made up from fixed amount of columns (25) and changing ...
0 votes
1 answer
14 views

Target range coordinates exceed sheet dimensions

starting new thread on new problem I encountered. I have a code below which is intended to copy a range of cells into last empty row on another tab in a sheet. When running I got an error saying ...
0 votes
1 answer
54 views

Extract Data from 2 columns if it matches condition

This is how my main data sheet looks like And for any item that has customization, for e.g. - ORGANIC, I want to extract/copy just those data, the meal name & total units to another sheet. And ...
0 votes
1 answer
21 views

How do I display an alternative charchter in a Doc that is pulling data from a sheet?

I have created an HTML form (not a Google Form) that populates a Google Sheet. The form has both text inpt and checkboxes (multiples of each.) On the Google Sheet, if a checkbox is checked on the ...
0 votes
1 answer
15 views

How to make the specific dropdown list reset to the specific choice daily?

Here is the basic layout of what I need. https://docs.google.com/spreadsheets/d/1t2FlKs3TTVsGp3co6SkFlfCb3EPDWv-i6g9su4o_flQ/edit#gid=1850242391 It's a daily check-in document that people come to ...
1 vote
1 answer
386 views

How do I copy data from multiple Google sheets and paste into master Google sheet while maintaining format?

Each day I paste assignments to employees in each employees respective sheet. These assignments have hyperlinks in portions of the data. At the end of each day I copy their assignments for that day ...
0 votes
1 answer
11 views

Why does my onEdit macro error when checking on an edit in a specific cell and sheet?

I've been battling with this for several days and used many previous answers found on these site, as well as a few others, but still can't get my script to run as intended. I have a dropdown box on ...
2 votes
1 answer
1k views

Email notification if cell value goes below set amount

I'm having trouble finding a Google sheet script that does what I need so I figured I would ask if someone could help me. Basically I have a simple sheet setup to track inventory of one item. There is ...
0 votes
1 answer
1k views

Add image in Google Doc from Google Sheet via Script

There is an image in Google Sheet (coming from Google Form) that I would like to insert in Google Doc in Image Format. Currently, I'm getting Url only from the below mention script. How can I get the ...
2 votes
1 answer
1k views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
0 votes
1 answer
38 views

Custom trigger to update values in a column from a formula

I have created a Google Sheet to store, edit and upload items I am selling on eBay. Originally I thought of using a calculator to calculate a selling price (Column O Sheet1). I found this link on ...
0 votes
1 answer
1k views

Google Script to set the current month once a day only in a cell

Currently, I'm using (Month(NOW()) to set the current month number in cell $D$1 of a spreadsheet. I know Month and Now are volatile functions and they're making the over sheet update way too slowly, ...
0 votes
1 answer
17 views

How to set C1=D1 then clear D1 Google Sheets using App Script

I'm currently working on a Google Sheet and want to be able to set the value of cell C1 to be the value of cell D1, and then clear cell D1 afterward. My issue is that once I clear cell D1, cell C1 is ...
1 vote
1 answer
238 views

Dynamic generation of sheet name from cell content (cell contents from importrange)

I have a list of names of the members of my group. Each member has a separate sheet that contains information on that member. When a new person joins the group, I input the name to the master list and ...
0 votes
2 answers
739 views

inputBox in onEdit does not work for users

I have a strange problem... Simple function like: function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var ui = SpreadsheetApp.getUi() var response = ...
0 votes
1 answer
29 views

Copy variable Range (based off cell value) to another tab

I'm struggling to set variable range to be copied into another tab in the same sheet. Fixed table range is defined as "Sprzedaż template!B84:Z95". Actually I would like to have that range ...
0 votes
1 answer
2k views

Create a custom DateTimePicker in Google Sheets

In a sheet I have a column to enter a datetime value that would later be checked by a script to create a trigger. I would like to set a picker in that column to ease selection and avoid errors. I ...
2 votes
1 answer
1k views

Put the timestamp of last edit on master sheet, next to edited sheet's name

I'm trying to come up with a script that will print a timestamp of the last edit made to a specific tab within a google sheet. Imagine you have 17 retail stores, each one having its own tab with a set ...
0 votes
1 answer
104 views

Google sheet: run a script via the share link (without login)

There is a script for my Google spreadsheet so that every change in a cell is indicated by a red color marker. When users with a Google account that I have shared to the spreadsheet make changes, the ...
1 vote
1 answer
26 views

How do I print a specific number of A based on a value from a cell in Google Sheets

There's a cell that would contain the number of times a letter would be printed in a cell. i.e. cell a1 = 3. b1 should look as "A A A" my rough script is: for(var arow=0; arow<4; arow++) {...
0 votes
1 answer
19 views

Schedule a script to run at midnight to append current date to sheet

How can I implement a script that each day at midnight will add a row to a sheets document, with the current date in it, below whatever the bottom cell is that is full?
0 votes
1 answer
2k views

Embed an interactive calculator in my website using Google Sheets

I have implemented a calculator in a Google Sheet, and would like to embed it in my website. There will be multiple users. They should be able to enter numbers and see the result, perhaps with a chart,...
0 votes
1 answer
1k views

How to include VLOOKUP with a loop for a list of data on Google Scripts?

I have a list of data on Sheet1 columns A-N, and a list of updates on Sheet2, columns A-N. I have a code that imports data to Sheet2, and I would like to add to my code a similar function to VLOOKUP. ...
0 votes
1 answer
18 views

Copying Values immediately based on other cell Values

I am collecting data from Google Form into a Google Sheet, in a Form Responses Sheet it has a column R that cell value changes (as the form responses can be editable), and the values can be Pending, ...
1 vote
1 answer
3k views

How to automatically set date in a cell when a different cell value is changed by a formula from data on another sheet?

I currently have a column, e.g. ColB, containing SUMIF functions with its data range from other sheets and a column, e.g. ColC, with dates that I want to automatically update to the last date ColB's ...
1 vote
1 answer
2k views

Auto hide row based on cell text (formula based)

My plan is to hide an entire row if a specific cell in the row showed specific value. I already found the script and the script work amazing. But the problem now, since the script use onEdit function, ...
0 votes
1 answer
114 views

Grant permissions on a shared google drive with script

I have google drive folder with subfolders, each subfolder has several google sheets and each sheet has a set of functions that run when users click on buttons, the issue is that for every time user ...
1 vote
1 answer
2k views

How to automatically forward Gmail messages when a label is applied?

I have found this question that is answered: How can I automatically forward Gmail emails when a label is applied? However I'm using that exact script and have replaced the label and recipient with ...
0 votes
2 answers
95 views

Converting Google Sheet to JSON format while rows are vertical

I am trying to convert the Google Sheets into JSON format using Google App Script. It worked but I am not getting the right format and I am little struck. My sheet looks something like this in the ...
1 vote
1 answer
33 views

Duplicate row values to next row, based off specific column

I'm trying to set up a button that will copy information from the last row and paste it into the row right underneath (based on where column D last has a value). Almost like a "duplicate" ...
0 votes
1 answer
87 views

Script to Copy multiple sheets from an Excel file and convert it to a Google Sheets file

I have an Excel file with 3 tabs (Sheet1, Sheet2, Sheet3) attached to a Gmail message and I would like these to copy to a Google Sheet file with 3 tabs (SheetA, SheetB, SheetC). The problem I am ...
0 votes
1 answer
19 views

How to get a notification when a column in google spreedsheets changes

I need help with a code. I need to get a notification on my email or Slack when for example, column D changes. But I would love to received what column changed. Here is what I got right now. function ...

1
2 3 4 5
35