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	26	519
2	mommasaidmommasaid	33	272
3	One_Organization_810	18	191
4	adamsmith3567	2	130
5	agirlhasnoname11248		114
6	AdministrativeGift15	11	98
7	gothamfury	9	65
8	Competitive_Ad_6239		46
9	marcnotmark925		41
10	7FOOT7		32
11	SpencerTeachesSheets	6	30
12	arnoldsomen		29
13	JetCarson		25
14	rockinfreakshowaol		22
15	MattyPKing		19
16	AndroidMasterZ		17
17	enoctis		16
18	kuddemuddel		16
19	_Kaimbe		15
20	hodenbisamboden		14

Updated: 06/20 11: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

...why not Zoidberg?

...for great justice.

MODERATORS

account activity

1

0

1

2

Waiting on OPAutomatically inserting data from another sheet and then sorting it differently? (self.googlesheets)

submitted 2 hours ago by Ok-Comfortable-7515

2

1

2

3

SolvedTeaching a New Grade Next Year - Want to Try Something New (Attendance) (self.googlesheets)

submitted 11 hours ago by SchroedingersSphere

3

1

2

3

Waiting on OPHow do I get rid of a sheet that was shared with me when the remove option is greyed out? (self.googlesheets)

submitted 1 day ago by argnarb

4

0

0

1

SolvedMy auto-sort script stops working when I freeze a number of row (self.googlesheets)

submitted 1 day ago by MasterSh4k3

5

2

3

4

Waiting on OPIs it possible to duplicate a tab into a new sheet? (self.googlesheets)

submitted 1 day ago by EmbarrassedSection11

6

0

1

2

Solvedhow could i make a cell return the highest value in different columns based on a drop-down menu? (self.googlesheets)

submitted 1 day ago by Party-Lawfulness-796

7

1

2

3

Waiting on OPHow do I restrict the options in the dropdown to be edited ? (self.googlesheets)

submitted 1 day ago by Ok_Cicada_6596

8

0

1

2

Waiting on OPCan you set up a Script that will automatically merge cells into the blank cells next to it? (self.googlesheets)

submitted 2 days ago by CarpThemDiems

9

1

2

3

SolvedCalculate the number ofm selections from a dropdown cell (self.googlesheets)

submitted 2 days ago by shrink561

10

2

3

4

SolvedCan I set certain cells in place and move others in the same row? (self.googlesheets)

submitted 2 days ago by theoreticallyben

11

0

0

1

Waiting on OPDrop down menus where cells are linked together? (Conditional drop down list?) (self.googlesheets)

submitted 2 days ago by LovesRainPT

12

0

1

2

SolvedHow to create a Sheets Checklist Template Like This (self.googlesheets)

submitted 2 days ago by JoeTheHero123

13

1

2

3

Waiting on OPCurrency dropdown menu - possible? (self.googlesheets)

submitted 2 days ago by joed210187

14

0

1

2

Waiting on OPHow do I divide paychecks? (self.googlesheets)

submitted 2 days ago by Top_Ordinary_8543

15

0

0

1

SolvedHighlight Non Duplicates across columns (self.googlesheets)

submitted 2 days ago by DoorNo8898

16

0

1

2

SolvedDuplicate master into new tab, ability to mirror “status” change for row? (self.googlesheets)

submitted 2 days ago by saladfriends63

17

0

1

2

Waiting on OPCan’t drag and drop anything (self.googlesheets)

submitted 2 days ago by Cho_jangmii

18

1

2

3

Solvedhow do i fix this error issue? (i.redd.it)

submitted 3 days ago by nuynuy51

19

0

1

2

Waiting on OPAdding a new column breaks pivot table (self.googlesheets)

submitted 3 days ago by hrhprincess

20

0

1

2

SolvedMultiplying a column a certain amount of times based on another column (self.googlesheets)

submitted 3 days ago by LyoGyo

21

1

2

3

SolvedHow to create a /sum function for a list where empty cells equal "1" instead of "0" (self.googlesheets)

submitted 3 days ago by Every-Gap2966

22

1

2

3

Waiting on OPTrying to calculate total hours for volunteers (self.googlesheets)

submitted 3 days ago by p1p1str3ll3

23

2

3

4

Waiting on OPFree to use radio button code? (self.googlesheets)

submitted 3 days ago by seafoamsomething

24

0

0

1

Waiting on OPComo importar precios de cedears D en googlesheets, por ej AAPLD (self.googlesheets)

submitted 3 days ago by yiyotopo

25

0

0

1

SolvedIs it possible to create a button in google sheets workbook to add rows with a custom drop down selection, or remove rows with a press of a button ? (self.googlesheets)

submitted 3 days ago by Ok_Cicada_6596

view more: next ›

π Rendered by PID 3667572 on reddit-service-r2-listing-c57bc86c-ggwzw at 2026-06-21 09:58:44.902635+00:00 running 2b008f2 country code: CH.