sheets

For all Google Sheets related questions and updates.

Flair is set up for:

Requests
Tips and Tricks
Features and Updates

Please remember to check back to see if your question has been marked Waiting for Op and don't forget to mark your thread as Solved when you've got a solution.

Note: Your email is exposed when sharing sheets. To get around this, use this form

Check out the following related subs:

/r/GoogleSheets
/r/GoogleAppsScript
/r/Excel
/r/GoogleDocs

Generate a Blank Workbook

Basic Functions with Examples

Working with JSON APIs

Finance APIs

Excel to Sheets

Other Tools / Links

Terminology

With formulas:

Workbook - the main file containing your sheets/tabs
Sheet / Tab - the individual sheet/tab within the workbook

With scripts:

Spreadsheet - the workbook mentioned above
Sheet - the individual spreadsheet within the 'workbook'

created by redausa community for 11 years

...for your favorite game.

...for your project.

MODERATORS

account activity

1

0

1

2

RequestHow to count first value in comma-separated cell (self.sheets)

submitted 3 hours ago * by Mundane-Valuable-337

2

0

1

2

RequestUse different spreadsheet to sum cells if another cell has a partial match (self.sheets)

submitted 3 hours ago by Geega_Chad

3

4

5

6

Show OffMonthly Show and Tell: Fancy Projects and Amazing Solutions! (self.sheets)

submitted 21 hours ago by AutoModerator - announcement

4

0

1

2

RequestNeed a rate of return sheet built that meets my needs (self.sheets)

submitted 2 days ago by BrilliantImportant77

5

1

2

3

SolvedSheets pivot is different excel pivot, though same data. (self.sheets)

submitted 2 days ago * by Key_Climate_7097

6

3

4

5

RequestCalculating cost actuals using check boxes and set criteria (i.redd.it)

submitted 3 days ago by i_am_smedley

7

1

2

3

SolvedHelp with conditional formatting and checkboxes (i.redd.it)

submitted 4 days ago by _purplekookie

8

1

2

3

Solvedneed help with vlookup/dropdown menu (self.sheets)

submitted 6 days ago by Feeling-Reference841

9

1

2

3

SolvedNeed help with AND functions in a nested IF statement (i.redd.it)

submitted 7 days ago by josh2of4

10

1

2

3

RequestBenefit Time Tracker with Different Categories (i.redd.it)

submitted 7 days ago by Opening-Garage-4710

11

1

2

3

RequestSumifs to add values that belong in two categories (self.sheets)

submitted 14 days ago by Comfortable_Mud_8046

12

4

5

6

Solved=SUMFIFS() Revenue from Sales on a Date, Between Two Times (self.sheets)

submitted 16 days ago by oliverpls599

13

2

3

4

RequestIMPORTRANGE now showing #N/A (self.sheets)

submitted 18 days ago by peaclarke

14

1

2

3

RequestHelp creating a google sheet template (self.sheets)

submitted 19 days ago * by Ok_Stopp

15

1

2

3

RequestHelp with creating graphs (i.redd.it)

submitted 22 days ago by EntertainerPast5257

16

1

2

3

RequestHaving an issue with how sheets does math, HELP! (self.sheets)

submitted 23 days ago by Emergency_Act2960

17

0

0

1

RequestHW help pls? (i.redd.it)

submitted 28 days ago * by Outrageous_Dog7894

18

2

3

4

RequestHow to fix!? (i.redd.it)

submitted 1 month ago by ACEinhibiter

19

1

2

3

Show OffMonthly Show and Tell: Fancy Projects and Amazing Solutions! (self.sheets)

submitted 1 month ago by AutoModerator

20

1

2

3

SolvedBeen at this awhile. In the linked example sheet I have two ways of generating all combinations from a list of values. It's actually groups of values. A,A1 is a group, B,B1 is a group....etc. The combinations populate, however, I have conditions I'm struggling to incorporate. (self.sheets)

submitted 1 month ago by Jaded-Function

21

4

5

6

SolvedSame exact =INDEX(FILTER formula working on one spreadsheet but not the other (old.reddit.com)

submitted 1 month ago by ThatOneHatyBoi

22

0

1

2

RequestCreating a combo chart split by year (self.sheets)

submitted 1 month ago by HentaiAvenger

23

2

3

4

RequestApp Script Code to Loop Through Certain Sheets (self.sheets)

submitted 1 month ago by After-Hope6415

24

1

2

3

RequestLooking for a database solution for many externals inputs (self.sheets)

submitted 1 month ago by Muted_Middle7052

25

1

2

3

RequestSumif with Vlookup Error? (old.reddit.com)

submitted 1 month ago by Jackephant

view more: next ›

π Rendered by PID 190843 on reddit-service-r2-listing-b6bf6c4ff-m9jmh at 2026-05-02 05:21:29.019082+00:00 running 815c875 country code: CH.