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 …

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 …

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 …

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 …

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 …

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 …

Google sheets automatic Notes [with onEdit() function] on cells’ values resulting from formulas

Is it possible to create automatic Notes based on cells variable values resulting from formulas ? For example A1=stxt(B1;1;4) gives “some” with B1=sometext (variable value), so that A1’s …

highlighting maximum values in a specific column using Google App Script

I`m trying to write a script that can find the maximum value in a specific column (proportion column in the given dataset) and highlight the cell accordingly. Below is where I am at so far function …

Get the values of particular columns and filter on a particular column – Google Apps Script

I have this script function filter2() { var sss = SpreadsheetApp.getActiveSpreadsheet(); //replace with source ID var ss = sss.getSheetByName(‘Users’); //replace with source Sheet tab name var range = …

reference does not exist with custom function – google script

I’m trying to call this API response using a custom function where I can change the parameters. This is my code: function callCandles(pair, start, end) { var response = UrlFetchApp.fetch(“…