Skip to main content
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 ...
Mike R.'s user avatar
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 ...
anva's user avatar
  • 15
-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 ...
Mirena Hristova's user avatar
-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 ...
maxhugen's user avatar
  • 1,948
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'...
Ken's user avatar
  • 81
-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 ...
Chris Sheeler's user avatar
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 ...
yuuuu's user avatar
  • 748
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: &...
Emanuele Benatti's user avatar
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 ...
Calvin Davis SR's user avatar
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 ...
Yash's user avatar
  • 1,008
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 ...
hohograndma's user avatar
-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 ...
jack's user avatar
  • 346
-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 ...
Matteo Social's user avatar
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 ...
Alexander Donovan-Lowe's user avatar
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 ...
Sagar agarwal's user avatar

15 30 50 per page
1
2 3 4 5
3747