Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post. Closed 1 year ago. Improve this question lets say i have a 3D array data with something like this (dynamically duplicates, sometimes 2-5 records) after processing from a sheet get range and
Tag: google-sheets
Nothing being Outputted after first Function Call – Javascript
I’m working on a javascript project that will list everything from user name, email, phone number, and notes from AD into into a spreadsheet, so far i have two functions. however anything i put after getExternalID(users[i].externalIds ||[] does not output any information. here’s a snippet of what i have. I’m a bit of a novice, would this be due to
How do I change my formula syntax to use variables
I’m trying to use set formula but it keeps saying I’m having an issue with my syntax but I’m not exactly sure how to fix it. I’m trying to use declared variables as the inputs to the formula. The bold line below is where I’m having the problem. Answer Use the concatenate operator + and the single and double quotes
Issue in creating script that copy the sheet and update it based on form response
I am trying to make a copy of Template in same folder when user submits the form and than update the fields in new copied sheet based on what user has submitted in the form response. New sheet is creating successfully but response I am getting in the form is not updating in the new sheet. Need help in finding
How to use apps script to count cells number and change the context in other column based on it?
Currently, I have three columns in my google sheets, column 1 is the company name, column 2 is industries name and column 3 is turnover (but the data is repeated). And I want to count the same company name and divide the turnover based on that number use apps script. Here are the example and result I want. This is
Adding Variables to getRange()
Having a hard time with the below Google Scripts JS code. Here’s what it’s supposed to do. Copy and paste info from active sheet from column M to column AA Go to sheet 2, get the last cell with data and add one row before pasting the new information. If nothing is there then paste to the top of the
custom chart using google sheets data
I’m new to this, so please bear with me 🙂 I have a google sheet with columns: ‘Name, A-Score,T-Score, R-Score, P-Score’ Scores are numerical values from 0 to 20. This data needs to be converted to a special, but very simple graph which i don’t think is available in the existing sheets charting options. I’ve tried to write some code
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
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