15 questions from the last 30 days
0
votes
1
answer
34
views
App script delete metacharacters for the complete string? [closed]
I am working on a Google form that will get automaticaly turned into a PDF once submitted. The Google sheet has roughly 350 headers with metacharacters. I need to find a way to make app script ...
Advice
0
votes
3
replies
64
views
Google Sheets, counting check boxes
I have a sheet with 2 checkbox columns. I need to count unique rows where a checkbox in either column is true or both checkboxes in the row are true. I have searched, at length, and can't find an ...
-2
votes
2
answers
87
views
How to find the total quantity of an item if 1) the item shows up in multiple rows and 2) the quantity shows up in multiple columns? [closed]
I've been trying to rawdog an inventory tracker for my school club. The spreadsheet tracks merch items that either go: 1) in 2) out or 3) initialized as a new item (through apps script), and every ...
- 5
0
votes
2
answers
61
views
How to display a column of dynamic length while being compatible with insert + shift down
I have a column of content, say A1:A15, that is meant to grow over time.
Visually, A1:A10 is fully occupied, and A15 is occupied. So I intend to insert and shift down using the blank cells as ...
- 10.1k
0
votes
2
answers
96
views
Google Sheets QUERY using SQL to compare two date columns across sheets
I'm trying to use a SQL query to simplify a sheet of complex data in Google Sheets, and having trouble selecting by a date. This will require some explaining.
The "raw-data" sheet has 2 rows ...
- 272
1
vote
2
answers
68
views
Getting value of a cell based on value of another cell, but not exact
So I'm trying to track some things. Let's say I have Sheet 3 which is the only editable sheet. It has a column under C which gets incrementing values input by a user each day.
Sheet 1 contains a list ...
-1
votes
1
answer
118
views
Google sheet extension showSidebar problem [closed]
My Google App Script has a design with two layers of HTML switching, as follows:
The user clicks on the UI to open the sidebar (index.html). The user can then select the desired feature, which ...
- 3
0
votes
1
answer
64
views
Trying to subtract from IMPORTRANGE
I would like the cell F4 to subtract from the corresponding F4 cell via IMPORTRANGE to get a week-over-week variance in item inventory.
This is what I have so far, but this looks like it's just ...
5
votes
1
answer
510
views
Google Sheets Apps Script "Working" does not disappear
For the last couple of days, whenever I call an Apps Script function there appears a small black window in the bottom centre of the sheet displaying a couple of spinning semi-circular arrows followed ...
- 43
0
votes
2
answers
61
views
passing a date object to a google app script function
This seems weird.
I have a cell a1: containing [Jan 1, 1984].
I have a function xxx
function xxx(d) {
return d;
}
if I try this in a cell like
=xxx(a1)
that returns 1
no matter what the year is.
if ...
- 2,907
1
vote
2
answers
103
views
Export data columns to text files named via cell reference?
I would like to export columns from a Google sheet such that the exported .txt files are named after the column heading. Is it possible to change the value of "column" + index below to be ...
- 13
-3
votes
1
answer
47
views
Change value depending on other field [closed]
I need to change the value of the dropbox in column J4 depending on the value in I4.
If I4 contains a value, then J4 should display a message like:
"Value needed, have a freaking cold winter&...
- 1
1
vote
1
answer
46
views
I am trying to use the value in a cell as an address to paste to another cell in google sheets via apps scripts. Use cell F8 which = C6 to paste to C6
I would like to paste from one tab to the address of a cell in another tab, where the value changes.
The problem I'm trying to solve is: how do I write the Apps Script code so that:
var spreadsheet = ...
- 13
1
vote
1
answer
95
views
Calculations from Timestamp based on Checkbox Iterative now() in Google Sheets
I don't want to use Google Apps Scripts, just formulas so that this can be display/edited on a mobile device while offline.
[
- 25
-1
votes
0
answers
31
views
Apps Script custom function result in Google Sheets being cached for cells where it has already been evaluated [duplicate]
Google Apps Script/Google Sheets issue...
The custom function in code.gs:
function SHEETNAME() {
return SpreadsheetApp.getActiveSheet().getName();
}
Then in Sheet1 cell A1 put:
=SHEETNAME()
A1 ...
- 1,131