I am trying to get an array to print out information from two different sources. I am looking for something that will look up one set of values, print the array. then take a value from the first array, use this in a vlookup type fashion, find the value in the second array, and then create a new array that
Tag: google-apps-script
Why do I get “ReferenceError: test is not defined”
Within my Google Script Project I got two GS files Code.gs and other.gs. code.gs looks like other.gs looks like when I run the function primary I get when I move the function other to the file code it works. Could someone explain why? Is there any way the other file could be anywhere in the project? Answer Explanation: Everytime you
Trying to write IF/AND statement in Google Apps Script
I have searched thoroughly but cannot find a the solution. I am trying to write an IF/AND statement in Google Apps Script. I will have 2-3 conditions with values coming from 2-3 columns respectively. Here is what I want the script to do If column A is ‘abco’ and column B is ‘swift’ then ‘double stack’ in column D If
Query & Timestamp Combined Script Not Working – Debug doesn’t show issue(?)
I am attempting to run a script that combines adding a timestamp upon edit to individual sheets, and also to place a query to create a master sheet of info from all sheets – both upon edit. Here’s the script I have: I’ve tried moving things around, but haven’t been able to locate where the issue is. Here’s a sample
How to clip list in cell in spreadsheet with Google Apps script?
Images: image1 , image2 I made a list as you can see in the image1. You can understand the list better if you look at image2. The list is in cell A1. I want to copy this list to cell B1 with google app script. getValue(), getValues() don’t work. These commands take the data selected in the list. But I
Find Google Sheets that matches a value in a cell of a sheet and execute a piece of code
I am sorry for this hideouts looking question but I have to ask. So bare with me. I am using google app script and trying to achieve following. I have two google spreadsheet books. 1.) Book A has only one sheet. 2.) Book B has 10 sheets. 1.) In Book A’s sheet column A contains range of text values. Ex:
Creating a Function to Process an RSS Feed in Google Sheets
I am trying to create a function that I can import into Google Sheets to view the latest bills from this website. A problem that I am having is that when I create only one variable to be appended to the Google Sheet this code will work and append the first cell. But when I create multiple variables using the
‘Range not found’ when trying to input value into first empty cell
Google Script/Spreadsheet issue, here. Am trying to copy data from one cell and put it into the first empty cell in column E. When I perform the following, I get ‘Range not found’ on line 15: I’ve tried replacing report.getRange(lastRow).setValue(row[1]); with something like report.getRange(‘E5’).setValue(row[1]); and it works fine, so there must be something wrong with my find empty cell/row function.
Trouble creating detail view tab in appscript
Actually I am trying to create information Modal in google sheets which extract data which matched the code, get the data from master sheet and it should display the data in Modal, but somehow I am having issue in passing the value extracted from master sheet to html output file and display it in modal. It is showing like this
Automating named Range function in google sheets
Context So I have a spreadsheet with 11+ sheets, though will be adding more later. I want to dynamically name the columns using named range. I created a macro script and have been using this. Only the problem is for every sheet, I have to go to the script and change the name of the named range: For example, for