56,202 questions
0
votes
2
answers
15
views
Why does my gsheet select only work when it is specified as an embedded string in the query function, but not when referenced as value in a cell?
Documentation says that the select parameter of the query function can either be a quoted string or a cell reference containing the string. However, I get different results when the same select ...
0
votes
0
answers
14
views
Is there a way in Apps Script to fill a table from an html file module, not depending on columns header and position?
Submitting a Google module linked to a Google sheet, the module answers are inserted into the right fields of the linked table in the Google Sheet, even if you change the table columns headers and the ...
-1
votes
1
answer
22
views
How to calculate my overtime (pm to am) in Google sheets? [duplicate]
My table
I have a problem when I try to calculate my Overtime and I'm looking for a working formula that can help me.
The formula, I use works for me perfect when I don't work from evening to early ...
-3
votes
0
answers
20
views
ArrayFormula With Header
A sheet that receives imported data has 4 cols. Col A has Datetimes, and in Col D I'd like to use an arrayformula to calc the minutes elapsed from the previous to the current datetime.
I've tried a ...
0
votes
1
answer
31
views
ARRAYFORMULA not filling merged cell values while preserving blanks
I'm working on a live Google Sheet with 25+ other users and some cells are merged. I want to create a helper sheet that fills down the info from merged cells while preserving intentional blank rows.
I'...
-4
votes
0
answers
26
views
Google Sheets / Apps Script - code lag sometimes means I am writing to wrong row
Maybe some of you have run into this same problem.
There is of course sometimes a lag between apps script and the actual sheet, particularly when getting/writing data to/from the sheet, like with ...
0
votes
1
answer
49
views
Plotting a cell's value in sheets as if another cell is changing
I have a spreadsheet with some calculations in it, and I want to make a plot of what happens to one cell's value as another changes (from 0 to 100). I have been searching for about 45 minutes and cant ...
0
votes
2
answers
28
views
How to tokenize a text in Google Spreadsheet
I have a cell (D2) in Google Sheets containing a title, and I want to extract everything up to the first punctuation mark (if any) and display it in another cell.
Example
For example, if D2 contains:
&...
0
votes
0
answers
44
views
Why does INDEX-MATCH fail with named ranges but work with cell references in Google Sheets?
I'm using Google Sheets and trying to create a formula that retrieves a value based on a match in a named range. The INDEX-MATCH function works correctly when I use cell references but returns ...
0
votes
4
answers
82
views
Index Match using Tables in Google Sheets not giving correct results
I have set up a sample sheet at https://docs.google.com/spreadsheets/d/1i3ZCE_9IvVyhrb-uK-ofMT3f0H_En1SfLSjbC8oyZlk/edit?gid=1600420249#gid=1600420249.
If I obtain the MATCH in a column and then use ...
0
votes
1
answer
29
views
How to send content as comment to a specific cell in google sheets
Using the Google Drive API and Python, I created a code that allows me to create a comment in a specific cell in Google Sheets when I type something into a form and click the submit button, but it ...
-1
votes
0
answers
66
views
Getting Blank Spreadsheet when emailing with Google Apps Script [closed]
I have a script that emails the contents of a Google sheet as an excel sheet.
I dont want to send the spreadsheet as is since there are other sheets which I dont want to send. So I get the data from ...
-2
votes
2
answers
96
views
Copy a formula to a new row of the same sheet [closed]
I have a google sheet where records arrive from a google form.
Is it possible to make it so that for each new row created (from the form) you can paste the formulas present in the row above?
I attach ...
0
votes
0
answers
27
views
How can you update specific cells in a google sheet from a goole microsite?
I'm trying to create a google site that my team will use as a data dashboard. It's not a colossal database or anything so just using google sheets for storing our data (a number of actions). Due to my ...
1
vote
0
answers
23
views
Google sheets equivalent of Explode in python? [duplicate]
I have a table with one of the columns containing a list of comma delimited values in google sheets. How do I transform each element of a list-like to a row, replicating index values.
Python ...