Questions tagged [google-sheets-custom-function]
Use this tag for questions about custom functions in Google Sheets created by using Google Apps Script.
100 questions
0
votes
1
answer
103
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 ...
- 429
0
votes
1
answer
445
views
Does Google Sheets have a function to insert X number of Y characters within a cell? [duplicate]
I currently have a spreadsheet which requires a variable number of line breaks within a cell based on input data from another cell.
Long story short, I currently am using a brute force method to ...
- 3
0
votes
0
answers
145
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 ...
1
vote
1
answer
556
views
How to return a Lambda Function through a Custom Function?
I know there are alternatives to this. You can simply pass the variables you want to pass to the custom function. But that's not what I want to happen. Something like:
=CUSTOMFUNCTION(A2,A3)(A4,A5)
...
- 1,140
-1
votes
1
answer
34
views
Subtracting Amounts from Specific Categories
I'm working on trying to make a relatively simple spending tracker using Google Sheets. In this example, the person has $5000 already in the bank, and they have earned $1000. The categories of Housing,...
- 1
3
votes
2
answers
764
views
How to select range into a cell based on drop down selection
I have two sheets in my Google spreadsheet: Meal Plan and Recipes.
Meal Plan looks like this:
Recipes looks like this:
I would like to write a formula or function which allows me to select a meal ...
- 205
0
votes
0
answers
129
views
Auto delete certain rows on the first of every month - Google Sheets
I've built a Sheet on Google Sheets with multiple tabs and formulas for me and my coworkers to use.
Only thing I couldn't do is set a formula that deletes multiple specific custom cells on multiple ...
- 1
0
votes
1
answer
247
views
Conditional Formatting Formula based on multiple criteria
I am needing help building conditional format formula for Google that meets the following criteria:
Column B email needs to appear more than 10 times
AND
Column I data needs to be "healthy" ...
- 3
2
votes
2
answers
5k
views
Google Sheets: Remove column headers from a QUERY()
I'm trying to eliminate (not hide) the column headings from the following QUERY(). The output from the =QUERY() must be in a single row.
=QUERY(myData!A:G, "Select SUM(E), SUM(F) WHERE D ='"&...
- 2,987
0
votes
1
answer
72
views
Google Sheets I need the column sums() of a table produced by a query()
I have a query() that outputs a table with two columns (A and B) of numbers. Pictured in IMAGE #1.
=QUERY(myData!A:G, "Select E,F WHERE D ='Books'")
IMAGE #1
But I need a function that ...
- 2,987
0
votes
1
answer
40
views
Counting different types of text and producing specific text outcome
So I'm trying to create a tracker where I can gauge a pass/warning/fail status for each category. Under "Report Status", I wanted a function that can put out the text "Fail" if one ...
0
votes
1
answer
669
views
Trying to change Gantt chart in Google Sheets to highlight a cell based on date range and progress percentage
I have been working on a dynamic Gantt chart template in Google Sheets for awhile now. Here's how it currently looks:
As you can see, the task bar currently highlights gray dependent on the start and ...
- 21
0
votes
2
answers
2k
views
Google Sheets sum-by-color function is no longer working. Possible to update?
Been using the following function to generate the sum of same-colored cells:
function sumColoredCells(sumRange,colorRef,test) {
var activeRg = SpreadsheetApp.getActiveRange();
var activeSht = ...
- 17
2
votes
1
answer
2k
views
How to pass multiple comma separated values in a cell to a custom function?
Suppose, there are values such as 1,A, 2,B, 3,D in certain cells. My intention is to add 1,2,3 (LHS) separately and A,B,D (RHS) separately. To achieve that, I have written certain custom function in &...
- 173
1
vote
0
answers
149
views
Auto-Populate document name into cell in Sheets [duplicate]
I'm looking to auto-populate the document's name into a single cell in sheets no matter if/when the doc name is changed. I can enter a formula from a script =DocName(), but it won't update when the ...
- 27