56,841 questions
Advice
0
votes
0
replies
26
views
Retain value of a cell
I have created a google form linked to a google sheet which captures users' request for a limited resource
It may be that the request fails because there were no resources left
However, the form also ...
0
votes
1
answer
59
views
Formatting "headers" of row groups based on content of the subrows
Example spreadsheet
How do I create a conditional formatting formula that does the following?
If all of the B rows of a group are TRUE (all boxes checked), the header row for that group gets formatted ...
- 219
Advice
0
votes
3
replies
49
views
Assign numbers based on date order
In the below screenshot I want a formula to get the values in column C, ie the Yellow box (currently showing the intended output).
Click image to enlarge it.
Basically it needs to check Column A. If ...
- 3
1
vote
1
answer
92
views
Can't fetch data from Google Sheets in Google Apps Script [closed]
update
I've found the issue. GAS can only send Strings, Numbers, Booleans, Arrays, and simple Objects from server to client. But some lastModified values are Date instances, so the client receive null....
- 17
1
vote
1
answer
66
views
ArrayFormula of SUMPRODUCT in Google Sheets [duplicate]
I have a Google Form which is linked to a Google Sheet
When a new form is submitted, I want some other columns calculated for the new row which has been created. I've done most of them using ...
-4
votes
1
answer
152
views
how to compute MD5 hash in Google Sheets using a single formula?
Is it possible to implement proper, fully fledged MD5 hashing using only native Google Sheets formulas? Especially since there is no native function like:
=MD5("text")
=ARRAYFORMULA(MD5(A2:...
- 132k
0
votes
0
answers
50
views
Issue using .addRange to modify chart
I'm having issues using .addRange to modify an existing line chart. When I run the following code the range does not get added, but the title does change. I've copied this almost exactly from the ...
- 1
1
vote
1
answer
83
views
Conditional formatting with custom formula skipping an empty cell
I have this formula:
=AND(B3<>"",$E3=INDIRECT("Mike Jones"))
applied to range: B3:G4569
It colors the entire row perfectly but skips the cells in column G if it is blank.
I ...
- 259
-1
votes
1
answer
73
views
Array formula with matrix decision
I run a small, rural health promotion/abuse prevention program through a non-profit and we have childcare providers and facilitators use a Google form to submit their time and mileage. When they're ...
-1
votes
1
answer
76
views
Google Sheets API PivotFilter.getFilterCriteria yields "Service error: Spreadsheets" when the filter contains a formula
PivotFilter.getFilterCriteria returns the expected result when the filter references values directly as in: 'Text contains A'. However, when the filter references formulas as in: 'Text contains =&...
- 25
-1
votes
2
answers
111
views
need code for this: when a cell is selected, highlight that row and all rows with the same value in column B
Need code for this: when a cell is selected, highlight that row and all rows with the same value in column B (table only, if possible).
I tried an even simpler code suggested by google, and it didn't ...
Advice
1
vote
2
replies
71
views
Matching a date in Sheet 2 to a corresponding row/date range in sheet 1, then grabbing a data value
Sheet1 looks like this:
A
B
C
Date Start
Date End
Pay Rate
1/8/2025
1/9/2025
1
1/10/2025
1/11/2025
2
1/12/2025
1/13/2025
3
1/14/2025
1/15/2025
4
...and Sheet2 looks like this:
A
B
C
Date Start
Date ...
- 11
Advice
0
votes
2
replies
86
views
Scripts to add column A from data sheet to destination sheets
In Google Sheets I have a Data Sheet with alphabetical names in Column A (and row 1 being a header). There is data in Columns B onwards that is specific to this sheet only (the Data Sheet)
When I add ...
user32447676
Best practices
0
votes
9
replies
125
views
What's the industry-standard way to, with a formula, fill a range with a specific value?
I'm using Google sheets. I'll use this table as an example
A
1
Apple
...
5
Apple
I know you can click and drag to autofill, I want a solution where
when I add a row anywhere between rows 1 and 5, &...
Tooling
0
votes
11
replies
170
views
I need to create a 3-column hierarchical table
I need a formula to create a 3-colums hierarchical table from an existing table with n³ rows. n ranges from 3 to 12. Lvl1 has n values, lvl2 has n², lvl3 has n³. The values don't have te be filtered ...
