Douglas Gaskell's user avatar
Douglas Gaskell's user avatar
Douglas Gaskell's user avatar
Douglas Gaskell
  • Member for 8 years, 5 months
  • Last seen more than a month ago
19 votes
1 answer
12k views

Conditional format rule "Text Contains" with a "+" misinterpreted as a formula

15 votes
2 answers
51k views

Conditional formatting with multiple criteria for a range of cells

7 votes
4 answers
8k views

Using Query with column headers instead of column letters

7 votes
6 answers
139k views

How to work around the IMPORTRANGE error: "Results too large"?

7 votes
5 answers
41k views

IMPORTRANGE() will not update unless deleted and re-pasted

5 votes
1 answer
3k views

Can I query a range of cells that match the criteria of another range of cells in Google Spreadsheets?

5 votes
1 answer
12k views

Filter a range by both Row and Column criteria in Google Spreadsheets

5 votes
1 answer
443 views

DGET is not successfully matching criteria in Time format

4 votes
1 answer
4k views

Query is returning a single concatenated string of values THEN the rows it found

3 votes
1 answer
1k views

How do I use DCOUNTA and get the month from a column instead of the entire date in the criteria?

3 votes
1 answer
977 views

Conditional formatting a range based on the value of a single cell inside of it

2 votes
1 answer
4k views

Trying to query a range of names in Google Spreadsheets, query is failing with the space in the names

2 votes
0 answers
2k views

Google URL shortener rate limit exceeded on first request [closed]

2 votes
1 answer
2k views

How to turn a month string into a month int in Google Spreadhseets

2 votes
1 answer
82 views

How do I sort a range of filters and functions?

2 votes
1 answer
100 views

Filtering a range by another range, custom function just says "internal error"

2 votes
1 answer
161 views

Dragging functions through multiple cells with spaces in Google Spreadsheets

1 vote
1 answer
545 views

How Do I filter this range of multiple rows and columns only by their headers?

1 vote
1 answer
38 views

Formatting work schedules in an easy-to-process, and easy to enter way?

1 vote
1 answer
75 views

FILTER() Is not returning consistent results

1 vote
2 answers
49 views

Google Forms submits times that are not numerically consistent with those in a spreadsheet

1 vote
0 answers
1k views

Filter() function randomly stops returning results

1 vote
1 answer
1k views

Can I auto-fill an answer on a form edit URL?

1 vote
1 answer
10k views

How do I filter the array returned by a filter or other formula?

0 votes
1 answer
824 views

Filter/Query a column of names by an array of names [duplicate]

0 votes
1 answer
2k views

Google Spreadsheet Query blanks out text cells in the query range

0 votes
1 answer
4k views

Can I filter or query an IMPORTRANGE in a single formula without importing the range multiple times or using a second worksheet?