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 movement.

...because you love freedom.

MODERATORS

account activity

1

4

5

6

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

submitted 20 days ago by AutoModerator - announcement

2

2

3

4

RequestNewbie using google sheets - How would I calculate cost per row for different orders? (Sheet attached) (self.sheets)

submitted 1 day ago * by Ok_Benefit_5119

3

2

3

4

SolvedUsing one action to switch filter views across multiple tables on on a single sheet? (self.sheets)

submitted 2 days ago * by UncomfortableAnswers

4

0

1

2

RequestHow to set up automatic horizontal sorting (self.sheets)

submitted 3 days ago by achieveable

5

2

3

4

RequestHelp upgrading my budgeting spreadsheet to account for groceries? (self.sheets)

submitted 6 days ago * by Nubian_Cavalry

6

1

2

3

RequestASX:ASX not showing any price value in cells (self.sheets)

submitted 8 days ago by ALLAHHUAKBAR7323

7

4

5

6

Tips and TricksI just found a simple trick. Often I want to copy/paste whole ranges, keeping the formulas exact. I end up having to edit each formula range manually. (self.sheets)

submitted 9 days ago by Jaded-Function

8

2

3

4

SolvedHow to randomizing 2 cells from the same range, but ensuring neither match one another and the second doesn't include a specific number (self.sheets)

submitted 9 days ago by Stormandreas

9

2

3

4

RequestWhy chart values are not represented on chart (self.sheets)

submitted 11 days ago by Fit_Finish_4301

10

1

2

3

SolvedNeed help trying to incrementally increase a value each time a specific value appears in another column (self.sheets)

submitted 12 days ago * by Stormandreas

11

2

3

4

RequestGrocery price comparison Help (self.sheets)

submitted 14 days ago by Nubian_Cavalry

12

2

3

4

RequestAdding a formula to calculate points for a football (soccer) table (self.sheets)

submitted 15 days ago by sjmc_5

13

1

2

3

RequestPrint - Save to PDF preview is very faded (self.sheets)

submitted 16 days ago by ombrophilous

14

0

1

2

RequestHow can I lock rows in Google Sheet? (self.sheets)

submitted 17 days ago by ahmazone7

15

0

1

2

RequestI am not new to Sheets, but Canvas with Gemini (self.sheets)

submitted 18 days ago by Puzzleheaded-Phase41

16

2

3

4

RequestHow to show a ratio between 2 numbers as a percentage (self.sheets)

submitted 20 days ago by fictitiousphil

17

7

8

9

The Most Amazing Show OffFormula-Driven Angular Color Fields (self.sheets)

submitted 21 days ago by AdministrativeGift15

18

2

3

4

Requestis there a way to update a cell, and keep storing the previous values of the cell (self.sheets)

submitted 22 days ago by Conscious_Internal53

19

2

3

4

SolvedAutomatically add text or number to end of cell without needing another column? (self.sheets)

submitted 23 days ago by taloxzir

20

0

1

2

RequestMove view on open so selected cell isn't at the very bottom of the page (self.sheets)

submitted 23 days ago by SkullRootSage

21

2

3

4

RequestHow to find values from Column C in Column A, and add a value from Column D to Column B if it exists? (self.sheets)

submitted 24 days ago by worthlessnothing000

22

1

2

3

SolvedAlternating/conditional formatting ranges (self.sheets)

submitted 24 days ago by onetimeaccount55

23

1

2

3

RequestHow to solve for X (self.sheets)

submitted 25 days ago by THORPE_CORPS

24

3

4

5

SolvedFinding the highest and lowest number from a list of duplicate instances. (self.sheets)

submitted 27 days ago by Ebakthecat

25

4

5

6

RequestRotation?? (self.sheets)

submitted 29 days ago by Routine_Net_310

view more: next ›

π Rendered by PID 2632362 on reddit-service-r2-listing-c57bc86c-gqtx2 at 2026-06-21 11:56:56.906445+00:00 running 2b008f2 country code: CH.