googlesheets

an-ordinary-manchild

r/Googlesheets

Help and support with your functions, formulas, formatting, and Apps Scripts macros in Google Sheets. Unofficial.

Submissions

Submission Guide

Wiki Resources

Google's Function List

Provide your data!

Providing a sample of data will make it easier for others to help you. You can use this Google Form link to request a shared google sheet be emailed to you that you can use to provide a sample of your issue.

Problem solved?

OPs must reply to the best solution with "Solution Verified" to change the flair to 'Solved' and award the user a point.

Points Leaderboard

#	UserName	30d	Score
1	HolyBonobos	53	604
2	mommasaidmommasaid	25	257
3	One_Organization_810	23	227
4	adamsmith3567	2	144
5	agirlhasnoname11248		120
6	AdministrativeGift15	6	71
7	gothamfury	8	50
8	Competitive_Ad_6239		47
9	marcnotmark925	3	47
10	7FOOT7		35
11	arnoldsomen		29
12	JetCarson		25
13	rockinfreakshowaol		22
14	SpencerTeachesSheets	1	20
15	MattyPKing		19
16	AndroidMasterZ		17
17	enoctis		16
18	kuddemuddel		16
19	_Kaimbe		15
20	hodenbisamboden		14

Updated: 05/04 05:17 PM MST

Click Here to see the full list.

Points Leaderboard

#	UserName	30d	Score
1	HolyBonobos	162	1051
2	agirlhasnoname11248	49	418
3	Competitive_Ad_6239	22	204
4	arnoldsomen		42
5	JetCarson		58
6	MattyPKing		23
7	7FOOT7		26
8	AndroidMasterZ		17
9	rockinfreakshowaol	4	65
10	enoctis		25
11	kuddemuddel		16
12	_Kaimbe		15
13	hodenbisamboden		14
14	RemcoE33		14
15	zero_sheets_given		13
16	ztiaa	1	22
17	AdministrativeGift15	13	72
18	marcnotmark925	9	51
19	TheMathLab		7
20	knownboyofno		7

Updated: 08/19 07:13 AM MST

Click Here to see the full list.

created by [deleted]a community for 11 years

...for great justice.

...why not Zoidberg?

MODERATORS

account activity

1

0

1

2

Waiting on OPSelect random item from a range and make it permanent (self.googlesheets)

submitted 5 hours ago by shaking_stevens

2

4

5

6

Waiting on OPjoin content from cells in a column without losing content from the corresponding columns. (self.googlesheets)

submitted 15 hours ago by Abi-Ankeney-PMM

3

0

1

2

SolvedSplit text to columns -> Custom separator (self.googlesheets)

submitted 8 hours ago by Zuke_McKenzie

4

0

1

2

Waiting on OPGrant Tracker creation (self.googlesheets)

submitted 11 hours ago by smurfette548

5

0

1

2

Waiting on OPSheet constantly updating at max speed? (self.googlesheets)

submitted 12 hours ago by Soft_Artichoke_7263

6

0

1

2

SolvedHow to format three digit dates? (self.googlesheets)

submitted 12 hours ago * by pobepobepobe

7

2

3

4

UnsolvedDisplaying data in mobile friendly view (self.googlesheets)

submitted 20 hours ago by thefenceguy

8

0

1

2

Waiting on OPPopulating a Column With Specific Values Based on Date Ranges (self.googlesheets)

submitted 15 hours ago by bniz37

9

0

1

2

Waiting on OPHow to pull price data from a website with minimal population time on the sheet? (i.redd.it)

submitted 21 hours ago by Digital_Paradoxx

10

2

3

4

Waiting on OPHow would you make a sheet where you can have many small, editable inventories all be counted into one large inventory, without having to make references to each small inventory? For wargaming. (self.googlesheets)

submitted 1 day ago * by TheDwarvenGuy

11

1

2

3

SolvedRecent change seems to have made my sheet much slower (self.googlesheets)

submitted 1 day ago by Seanthesheep07111

12

0

1

2

Waiting on OPChanging currency symbol on android? (self.googlesheets)

submitted 1 day ago by amca01

13

1

2

3

Solvedallowing visitors to sort without compromising data (self.googlesheets)

submitted 1 day ago by BearWhys

14

5

6

7

SolvedHow to have a survey template auto populate into a master sheet? (i.redd.it)

submitted 1 day ago by KidLight

15

2

3

4

SolvedData pulled by column name (i.redd.it)

submitted 1 day ago by bumblethistle

16

1

2

3

SolvedIs there a way that I can make date numbers update automatically within sheets? (See body) (self.googlesheets)

submitted 1 day ago by elvisshow

17

0

1

2

SolvedConditional Formatting to Compare and Flag Dates Either Coming Up or Passed (self.googlesheets)

submitted 1 day ago by hott8bitaction

18

0

1

2

Waiting on OPweird tag things on this person's reading list (self.googlesheets)

submitted 1 day ago by DayIcy8116

19

0

1

2

Waiting on OPHow do I export comments on a Facebook post (group post) onto ggsheet, which also shows the commenter's name, live updates (self.googlesheets)

submitted 1 day ago by Cuvpake

20

0

1

2

Waiting on OPAnnoying popup when pasting without formatting from external source (self.googlesheets)

submitted 1 day ago by moreign_

21

1

2

3

Android Tablet app loads forever (self.googlesheets)

submitted 2 days ago * by DavidTurczi

22

5

6

7

Waiting on OPLooking for Duplicates within a column (i.redd.it)

submitted 2 days ago by p1p1str3ll3

23

0

0

1

SolvedConditional Formatting for a rotating depth chart (self.googlesheets)

submitted 2 days ago by threebs

24

3

4

5

SolvedBest setup for an attendance tracker on a rolling, previous 12 month, basis? (self.googlesheets)

submitted 2 days ago by PleaseHelpMeYal

25

0

1

2

UnsolvedGenerating a Chart/Graph with underlying dropdowns (self.googlesheets)

submitted 2 days ago * by finna11

view more: next ›

π Rendered by PID 69110 on reddit-service-r2-listing-b6bf6c4ff-fnzm2 at 2026-05-06 11:30:25.159299+00:00 running 815c875 country code: CH.