User Douglas Gaskell

19 votes

1 answer

12k views

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

asked Oct 6, 2015 at 3:01

16 votes

2 answers

51k views

Conditional formatting with multiple criteria for a range of cells

asked Oct 18, 2015 at 23:28

8 votes

4 answers

9k views

Using Query with column headers instead of column letters

asked Dec 22, 2015 at 8:41

7 votes

6 answers

150k views

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

asked Jan 9, 2016 at 23:17

7 votes

5 answers

42k views

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

asked Sep 28, 2016 at 3:06

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?

asked Nov 21, 2015 at 23:51

5 votes

1 answer

13k views

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

asked Oct 26, 2015 at 21:43

5 votes

1 answer

450 views

DGET is not successfully matching criteria in Time format

asked Sep 26, 2015 at 4:11

5 votes

1 answer

4k views

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

asked Sep 27, 2015 at 22:45

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?

asked Oct 27, 2015 at 22:32

3 votes

1 answer

981 views

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

asked Oct 27, 2015 at 23:26

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

asked Nov 5, 2015 at 2:37

2 votes

0 answers

2k views

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

asked Nov 17, 2015 at 0:39

2 votes

1 answer

2k views

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

asked Oct 24, 2015 at 1:46

2 votes

1 answer

85 views

How do I sort a range of filters and functions?

asked Oct 12, 2015 at 20:01

2 votes

1 answer

101 views

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

asked Oct 13, 2015 at 2:25

2 votes

1 answer

182 views

Dragging functions through multiple cells with spaces in Google Spreadsheets

asked Oct 11, 2015 at 2:02

1 vote

1 answer

545 views

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

asked Oct 11, 2015 at 22:06

1 vote

1 answer

43 views

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

asked Oct 10, 2015 at 20:20

1 vote

1 answer

85 views

FILTER() Is not returning consistent results

asked Sep 28, 2015 at 3:37

1 vote

2 answers

52 views

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

asked Sep 28, 2015 at 23:12

1 vote

0 answers

1k views

Filter() function randomly stops returning results

asked Oct 1, 2015 at 21:52

1 vote

1 answer

1k views

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

asked Nov 18, 2015 at 0:50

1 vote

1 answer

10k views

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

asked Dec 28, 2015 at 3:16

0 votes

1 answer

829 views

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

asked Sep 25, 2015 at 2:55

0 votes

1 answer

2k views

Google Spreadsheet Query blanks out text cells in the query range

asked Feb 26, 2016 at 22:27

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?

asked Feb 27, 2016 at 2:53

Stack Exchange Network

27 Questions

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

Conditional formatting with multiple criteria for a range of cells

Using Query with column headers instead of column letters

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

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

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

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

DGET is not successfully matching criteria in Time format

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

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

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

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

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

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

How do I sort a range of filters and functions?

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

Dragging functions through multiple cells with spaces in Google Spreadsheets

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

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

FILTER() Is not returning consistent results

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

Filter() function randomly stops returning results

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

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

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

Google Spreadsheet Query blanks out text cells in the query range

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