Skip to main content
Sherwood Botsford's user avatar
Sherwood Botsford's user avatar
Sherwood Botsford's user avatar
Sherwood Botsford
  • Member for 10 years, 2 months
  • Last seen more than a month ago
5 votes
1 answer
17k views

How can I speed up Google Sheets?

5 votes
3 answers
9k views

Recalculate google sheet on demand:

3 votes
3 answers
5k views

Is there a way to get 'frozen' rows in an embedded Google Sheet?

3 votes
3 answers
6k views

Automate range name creation in Google Sheets

3 votes
0 answers
172 views

Under what conditions does gmail group distinct replies into a single thread? How can I force separate threads?

3 votes
2 answers
1k views

Is there a way to manage a gmail account without access to a cell phone?

2 votes
2 answers
537 views

Complex views in embedded Google Sheets

2 votes
1 answer
3k views

How can I turn a list of comma separated values into an array?

2 votes
1 answer
105 views

Is there a way to convert gmail attachments to gmail docs, and replace them in the message with links to the drive file?

2 votes
1 answer
1k views

How can I make the active sheet's tab stand out?

1 vote
3 answers
796 views

Given a shared Dropbox link to an Excel file, how can I easily open it in Google Sheets?

1 vote
2 answers
1k views

How do I use regexmatch inside sumproduct?

1 vote
1 answer
450 views

Pivot table on the results of a query

1 vote
0 answers
33 views

How can I copy pictures I posted in other groups to my own album

1 vote
1 answer
4k views

How can I format a pivot table with staggered elements to make narrower?

1 vote
1 answer
83 views

How can I avoid INDEX MATCH on google sheets?

1 vote
1 answer
409 views

Pretty print google sheet formula?

1 vote
1 answer
397 views

speed up google sheet with large pivot table

1 vote
2 answers
2k views

How do I find out what is slowing down google sheets?

1 vote
0 answers
23 views

Google gives incomplete results on self search [duplicate]

1 vote
1 answer
325 views

Does Google Sheets do "lazy" calculation?

1 vote
0 answers
30 views

Is there a way to change the print dialog in Google sheets to either default to last selection OR to "selected cells"

1 vote
2 answers
222 views

How do I count the number of times string "A" occurs in cell B1

0 votes
1 answer
2k views

Google Sheets pivot table won't show totals for more than one Row item

0 votes
1 answer
751 views

More compact version of nested substitute function possible?

0 votes
1 answer
2k views

Can I eliminate redundent totals in google pivot tables?

0 votes
1 answer
4k views

How do I troubleshoot "Query completed with Empty Output" in Google Sheets?

0 votes
2 answers
14k views

How can I repeat Item labels in Google Sheets pivot table?

0 votes
1 answer
183 views

What is a cut and paste approach to converting a chunk of a google spreadsheet to markdown table?

0 votes
1 answer
2k views

How can I optimize lookups in google sheets?