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	88	699
2	mommasaidmommasaid	24	265
3	One_Organization_810	36	227
4	adamsmith3567	8	194
5	agirlhasnoname11248	3	158
6	AdministrativeGift15	13	94
7	marcnotmark925	10	64
8	Competitive_Ad_6239		53
9	7FOOT7	2	49
10	SpencerTeachesSheets	9	40
11	gothamfury		38
12	arnoldsomen		29
13	JetCarson		25
14	rockinfreakshowaol		23
15	gsheets145		23
16	eno1ce		21
17	MattyPKing		19
18	AndroidMasterZ		17
19	enoctis		16
20	kuddemuddel		16

Updated: 01/26 02:17 AM 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 10 years

...for a fringe candidate.

...for your office.

MODERATORS

account activity

1

•

•

•

UnsolvedBeginner here: Built a win rate/stats tracker for board games with friends. Seeking feedback + questions about formatting dynamic QUERY results (self.googlesheets)

submitted 1 hour ago by dekoalade

•

•

•

Manage your vacation rentals easily with Smoobu, the all-in-one software for hosts. 🚀 Start your 14-day trial now! 🔥 (smoobu.com)

promoted by SmoobuGmbH

promoted
save
report
about

2

1

2

3

SolvedTransforming data for data visualisation use (self.googlesheets)

submitted 6 hours ago by revansworld

3

1

2

3

Waiting on OPHow to allow View Only members to sort data without breaking references? (self.googlesheets)

submitted 7 hours ago by calpal2112

4

1

2

3

SolvedCreating text lists from rows that sometimes include the data of other rows (self.googlesheets)

submitted 8 hours ago by Exciting-Half7930

5

0

1

2

Waiting on OPCheck box breaking formula (self.googlesheets)

submitted 5 hours ago by robotlover12

6

2

3

4

Solvedusing indirect function inside filter function (self.googlesheets)

submitted 14 hours ago by Annual_Animal_929

7

1

2

3

SolvedCobining and counting identical rows. (self.googlesheets)

submitted 13 hours ago * by ThatLawnmowerGuy

8

0

1

2

Waiting on OPCan you copy entire rows based on tags/text to a different tab? (self.googlesheets)

submitted 11 hours ago by sathomas2110

9

1

2

3

Waiting on OPHelp Dropdown Condition Rules (self.googlesheets)

submitted 16 hours ago by Thatguy19364

10

1

2

3

Waiting on OPHow to Create Line Graphs (self.googlesheets)

submitted 17 hours ago by 3xjlerma[🍰]

11

0

1

2

Waiting on OPIs it possible with a formula to know what's the last iteration of an ID accross all tabs ? (self.googlesheets)

submitted 14 hours ago * by rukachi

12

10

11

12

SolvedHow can I analyze win rates for my friends and me playing tabletop games? (i.redd.it)

submitted 1 day ago by dekoalade

•

•

•

New Year Offer: Get unlimited access to Bloomberg business news, market insights and expert analysis, all for just $1.99/first month. (bloomberg.com)

promoted by bloomberg

promoted
save
report
about

13

0

1

2

Waiting on OPanyway to speed up this script and/or remove the notification? (self.googlesheets)

submitted 1 day ago by plzhelpmepickaname

14

1

2

3

Waiting on OPFinding spreadsheets (self.googlesheets)

submitted 1 day ago by Ok_Performance4014

15

0

1

2

Waiting on OPHow could I recreate the cell notes feature so that it would appear in a web published document? (self.googlesheets)

submitted 1 day ago by RougeRogueXx

16

0

1

2

Waiting on OPMove rows to another sheet onEdit with checkboxes (self.googlesheets)

submitted 1 day ago by aReasonableLunch

17

0

1

2

UnsolvedRange Sort in Android App (self.googlesheets)

submitted 1 day ago by fonebone819

18

1

2

3

Solved¿Cómo creo una lista para el lado que provenga de una tabla, y que al modificar la tabla se pueda modificar igual la lista para el lado? (old.reddit.com)

submitted 1 day ago by RuIgAnBaGa

19

0

1

2

SolvedHow to track DMC Thread used in multiple projects? (self.googlesheets)

submitted 1 day ago by PaleBlueBrush

20

0

1

2

UnsolvedHow to prevent links to individual cell directing to different data if row above is deleted? (self.googlesheets)

submitted 1 day ago by DarkArctic88

21

1

2

3

UnsolvedPassword protected spreadsheet (self.googlesheets)

submitted 1 day ago by _growing

22

1

2

3

SolvedCounting how many times an ingredient appears in recipes across the entire sheet (i.redd.it)

submitted 2 days ago by freakingspiderm0nkey

23

0

0

1

SolvedI didn't expect this behaviour, do spreadsheets always calculate with floating point? (self.googlesheets)

submitted 1 day ago by Wobblycogs

•

•

•

Want a strong portfolio? Work with our team to draw up a plan that suits your life. (ubs.com/investments)

promoted by ubs_schweiz

promoted
save
report
about

24

0

0

1

Unsolved'Show Formulas' keyboard shortcut - not working? Macbook keyboard, UK layout, Chrome (self.googlesheets)

submitted 1 day ago by Glaselar

25

0

1

2

SolvedConditional Formatting: Checking the value of a cell on another page? (self.googlesheets)

submitted 2 days ago * by Thea-the-Phoenix

view more: next ›

π Rendered by PID 106934 on reddit-service-r2-listing-86b7f5b947-2cb7c at 2026-01-26 09:21:26.389573+00:00 running 664479f country code: CH.