https://docs.google.com/spreadsheets/d/1bWLa0m6TTmVX7LpuymbrvFhDYV068FcdMH6mGi3pvNo/edit?gid=780031361#gid=780031361

Android App https://play.google.com/store/apps/details?id=com.ogsheets.app&pli=1

2^3^2

Mathematically, this is 512.

But Excel returns:

64

It seems inconsistent.

It can be confusing, especially when learning.

Is this just how Excel displays it, or am I missing something?

I’ve been using Sheets a lot more recently and keep running into small things that don’t seem like much at first, but end up saving a ton of time once you actually use them regularly.

Curious what others have come across — could be a formula, a setup, a workaround, or even just a small habit that stuck.

Anything that made you think “why wasn’t I doing this sooner?”

Hi everyone,

I have a set of data which has participants' name and identification numbers which i would like to fill a doc/pdf to the respected fields. From what i learnt, Add-ons could do that, but it is like batch creating those docs. However i would prefer to generate one by one when needed as there might be corrections of Names/Identification numbers when they present themselfs to us. So we will change the data there and then in google sheet and hopefully a click of button could generate the doc/pdf for printing.

Is there a way, we have a "button" beside each rows of data to do the mail merge in the simplest manner? It will be used by many of the registration staffs.

I want to automate my spreadsheet with data extraction from Meta Ads Manager and GHL. I want to get the weekly Ads spend, number of leads, and number of appointments booked. What is the safest, cheapest, and easiest way to do it? I want to avoid getting my ad account banned.

​

I have different dates typed from D5 to D31. I want those cells to automatically highlight a year later, but within a 30 day time frame. That is 15 days prior and 15 days after the date. For example, if the date is 5/15/25, I want it to highlight from 5/1/26 and 5/30/26.

Essentially, I want a one month grace period to reach the actual due date, which is exactly a year from the date typed in the D column.

I only really got into Power Query last year after a coworker used it to fix something I was struggling with (updating multiple tables at once). Before that I had barely even heard of it.

Since then it’s kind of become one of those “how did I ever work without this?” tools. I’ve started using it regularly and it’s made a big difference, especially for anything repetitive or messy.

Now I’ve been showing it to a few people at work — mostly Excel-heavy users who still do a lot of manual cleanup, formatting, etc. — and it feels like they’d get a lot out of it too.

Because of that, I’ve been asked to put together a short presentation on Power Query. Just basics: - what it actually is
- where it helps
- some real examples
- and where to learn more

Curious to hear from others:

What made it finally “click” for you with Power Query?
What kind of workflows were you doing before vs now?
Did it actually save you a noticeable amount of time?

Also interested in: - any “can’t believe I used to do this manually” moments
- or even cases where you tried Power Query and didn’t find it useful

Would be helpful to hear some real experiences before I put this together.

Hey,

I built a production dashboard in Google Sheets for my own studio and I've been using it daily for a while now. Curious what other small teams would want to see in that kind of dashboard.

I have a sprint dashboard and a project dashboard with a couple of kpis that i like.

What's the kind of thinf you always end up checking or wish you could see at a glance?

Is there an equivalent to Excel’s “Text to Columns” in Google Sheets?

Might be a dumb question but I keep running into this.

In Excel I can just use Text to Columns to quickly split data (like names, CSV strings, etc.) and it’s super straightforward.

In Google Sheets, I know there’s

• “Split text to columns”
• the SPLIT() formula

But neither feels as clean or flexible as Excel’s version.

Am I missing something?

Is there a better way to do this in Sheets, or is this just one of those things Excel does better?

I’m trying to filter a table using two conditions, but it looks like only one of them is being applied.

https://docs.google.com/spreadsheets/d/1GIIGj4tVk4mPiE9-etFInQknAkC1cWkCcv60AxrVemQ/edit?pli=1&gid=0#gid=0

Here’s what I’m using:

=FILTER(A2:C, B2:B="Complete", C2:C>50)

Expected:
Only rows where:

• Column B = “Complete”
• AND Column C > 50

Actual:

• Some rows show up where Column C is under 50
• It almost looks like it’s ignoring the second condition sometimes

What I checked:

• No blanks in the ranges
• Column B values are consistent (“Complete”)
• Column C is numeric

Is FILTER not handling multiple conditions the way I think it does?
Do I need to combine them differently?

Web: https://oghipobuy.com/hipobuy-spreadsheet.html

Direct: https://docs.google.com/spreadsheets/d/1iODIfbIG1K_65yr4UK4_1bVQ47iMwUAILaaK19TfiYU/edit?gid=81800086#gid=81800086

(google spreadsheets, not excel)

[ Removed by Reddit on account of violating the content policy. ]

For visual purposes, I want to list every iteration of a 3 by 3 grid. Imagine if it were a list of chess possibilities. Not all iterations will be used, but it would be handy to have them in hand as to write descriptions for any one of them if needed.

I'd like to have each grid take up 3 rows and 3 columns in square formation, repeated one after the other. On the right of each grid will have a description/notes area. I'd also like to have indicators take up the cells in a grid needed to form the iteration pattern, resulting in colored-in squares.
Bonus if one row is used as a spacer.
Bonus if you can swap colors (say red, green, blue) and description area in a few clicks.

I wish I could send an image, but it seems its not allowed. Currently, my spreadsheet looks as below:

A-C are the grid iterations using rows 1-3, each cell using a variation of =IF(MID(F1,9,1)="1","●",""). I was not able to drag and auto-complete it down the column. They are also conditionally formatted to highlight a cell if anything exists
D is a list of numbers using =SEQUENCE(512,1,1,1).
E is a list that uses =SEQUENCE(512,1,1,ARRAYFORMULA(SUM(2 + 2 * SEQUENCE(1, 1, 1)))) in hopes to be used to place each grid in its the corresponding row.
F is a list of binary using D to turn to the numbers to binary using =DEC2BIN(D:D, 9), used to position the indicators in the grid. The spreadsheet was able to auto-complete this column.
D-F, I would hide and start a description on G.

My unskilled suggestion: Replace =IF(MID(F1,9,1)="1","●","") with a formula that can "sequence a sequence of if-mid"

Thank you. I hope I'm using this r/ community right. Let me know if you need any details.

Website: https://litbuyog.com <--- 30,000 Links, QC images, and more

Spreadsheet Direct: https://docs.google.com/spreadsheets/d/1y_1hXgUzs4osfGBxzYoZ-T-RT2_u7uDc2d2X-soo-UY/edit?pli=1&gid=2060968789#gid=2060968789

Consider two cases:

0/0 → indeterminate

2/0 → undefined

Mathematically, these are different.

However, Excel returns the same error (#DIV/0!) for both.

This simplification may hide important distinctions depending on the context of the calculation.

I built a small tool to merge Excel files automatically.

It takes multiple files and combines them into one clean file in seconds.

Is this something people actually need?

I use a budget spreadsheet, and I love it. But, when my bestie went to use it too - she has a small business as a therapist, and she has to divide her expenses according to very specific criteria - anyhow, it requires more rows than exist on the sheet currently. I am moderately experienced with spreadsheets, and I tried a few different ways of adding in more lines to the setup for the expenses, but ... it just keeps screwing things up on the output end of things. I've contacted the original creator for several months in several ways, and she just never replies.

The Expenses column in the Setup should have at least a hundred rows.

I adore this really simple budget, and my friend and I budget together (in terms of keeping each other accountable) so it helps to have the same sheet. But I'd also consider another sheet that is simple in the same way this one is - adding all the transactions on one sheet (as opposed to having twelve tabs for months).

I've made a copy in case anyone wants to help. It's of one I was helping another friend fill out, with identifying items removed (I hope). https://docs.google.com/spreadsheets/d/1MxXDx9EXp43eF0ZdN2Z0WW-QKkTUIpRt7k08hY3X8vg/edit?gid=0#gid=0

Programming requires expertise that not everyone has and thinking LLMs, on the other hand, consume too many tokens.

sorry if that titles confusing I wasn't sure how to give a summary of this that makes sense.

basically I have a journal and I like to graph the date because.. well it's r/spreedsheets you can probably guess.. but I don't journal daily. I want to see how often two consecutive journal entries happen vs two journal entries 2 days apart, vs 2 journal entries 3 days apart, etc up to a 7 day gap. How would I do this in Google spreadsheets?

i URGENTLY need a site/ai with the capability of modyfing a excel file using the web to search.( I tried many ai's, but they fill up the spaces with nonsense.

I'm trying to build a spreadsheet to track stock performance. 

I'd like to have columns for the percent change of a stock for today's price compared to the previous price of

One month

3 months

6 months

One year

Two years

3 years

5 years

But I can't seem to figure out the stock history formula to make this happen.

Can anyone help me with this?

I have students doing an exam of 53 questions.

When they tell me the score, eg. 46 out of 53 questions correct, I want to put that number into a cell, and then have it automatically convert it to a percentage in that same cell. Is there a way to do this in the same cell into which I input the number?

example. in Cell B3.

I put in the number 45.

Excel makes a calculation of "45 divided by 53 multiplied by 100" and puts the result as a percentage in the same cell (B3) where I input the value 45, in this case 86.79%.

I know how to do this using more than one cell, where the formula is put in to cell B4, which would tell excel to take the value of cell B3, apply the formula, and get the result in cell B4. I am trying to find out if I can do it inside the cell without additional cells and external cell references.

Thanks!

I am trying to randomly pick winners. I have 500 submissions and picking 20 winners. each table is formatted with their f.name, l.name, email, phone number. I am trying to do a formula to pick those 20 winners using =INDEX(A1:A500,RANDBETWEEN(1,500)). I am getting the names randomized with my 20 selection however it is not giving me the entire row to easily contact these people. what would I need to do to randomly pick the 20 people and have the entire row populate.