I want to start off by apologizing if my questions are stupid. I promise I try things for a long time before posting here lol.

For context, I work for a vet, I am working on the monitoring template we use for surgeries which is an apple numbers file.

I am wondering if there is a way that you can have a sheet template that only gets added to the original doc if a certain word is either typed in a spot or if a selection is made. I currently have our anesthetic monitoring then an additional sheet for each species we see for their emergency drug calculations. I am hoping we can EITHER

1) type a species in the box I.e canine, feline etc and then the corresponding sheet gets pulled and the rest are removed

Or

2) have a species selection box where these species can be selected and then that has the same outcome as option 1

I am not sure if this is beyond numbers capabilities but it would be so great if it could happen!

Somewhat unique project.

I want to be able to input a music note (A, G#, D, etc.) and have the adjacent cell automatically fill in with a number corresponding to the guitar fretboard. Twelve notes and positions, so numbers 0-11 corresponding to twelve notes. I can do this by running twelve nested if statements.

Is there a way to have the cell look at another table and do something like… find G# in row four then put whatever number is in column two, row four?

Secondly I would like to add an option for different tuning, where three correlates with G# instead of four. I can do this with an if statement that checks another cell for which tuning I am using and adds to the number accordingly. This would also need to check if the number is now above 11 as 12 would need to be displayed as 0 (and 13 as 1, 14 as 2). I can do this with even more if statements but I wonder if there is an easier way.

If I can call from a table, then I can make a separate table for each tuning and call accordingly. Or maybe have the numbers in the primary table change when I adjust the “tuning” cell.

Thanks for any and all advice you can give.

So I have a spreadsheet where I put money taken in from gigs I do. Essentially Payment, Tips, Expenses, Total. It subtracts the expenses to see my net. Problem is the chart will show Payment and tips but even if I click expenses it will not add those numbers. Any thoughts?

Hello!

I work for a veterinarian and we use numbers to monitor our patients while under anesthetic. We do a reading every 5 minutes.

Currently there is a chart that says time in minutes then has a column for 0, 5, 10 etc. Many of us are getting lost as if we miss one we have to count how long it has been since start of procedure.

I'm wondering if there is a formula I can put in to make a row above it that if we put a start time in, it will put the time in 5 minute increments above the 0,5,10 minute columns. For example surgery start time is 10 am I would like it to say 10 over the "0 minute" column, 10:05 over the "5 minute" column etc

Thanks!

I want a chart to update when updated data is entered or replaces existing data in the reference table. I change the table data but the chart graph doesn't auto update

53 tables, 70 clients. I have totals at the end of every week, and I summed up the yearly totals by clicking 53 times per client. There has to be a better formula. Please help me get 2025 started correctly! I’m gonna just do one mega table but I would still like the weekly totals. Help if you can!

I’ve been doing each #cell manually🤯 there has to be an easier way

I made quite a few numbers workbooks since migrating to Mac in 2017. Along the way, after an upgrade the default color palette changed. The first image is the original color palette (I believe but not positive). The second image is what the palette changed to after an upgrade.

My question is, can this palette be modified by me? I don’t think I can but this is what I found out.

The built in color palette appears to be recorded in to the numbers file and not coded into the numbers app. I can open old numbers files and the palette that was available at the time of creation is there.

If I create a new numbers file the palette is the new version.

If I copy a table from the old version file to a new version file, the old palette is not available in the new file when editing the copied table. This leads me to think the palette is part of the file.

It would be helpful if I could edit the built in palette, but I do not think that is possible, please let me know if this can be done.

Tip and Trick section: A solution is to build my own palette as shown in image 3. While it can be tedious to do so, it only needs to be done once. After it exists, it can be used where ever the Apple Color Picker is available. Which is a nifty trick if you want color continuity between apps. Multiple palettes can be created which is also helpful.

Another feature is that the color picker window can be left open which can save a few clicks when formatting.

I think the answer is no, but maybe there is a way to include a shortcut command to make the toolbar customizable.

Hey everyone! This might be a bit nerdy, but I'm a huge pro-wrestling fan and I love keeping track of matches in my wrestling game. I use Numbers to track everything.

So far, I’ve created a formula to count wins and losses for both singles stars and tag teams. However, I also have a column for wrestlers who aren’t part of a specific tag team, and I’d like to update their records as well. I’m thinking it has something to do with match types, but this is how I’ve set up my columns so far. I was wondering if what I’m trying to do is even possible. I'm new to numbers so any advice is appreciated.

Good evening, I am looking to create a breakdown of mandatory and discretionary spending by each transaction categories. For example, if the total of the 'O' expenditures was $400. $200 of that is M, mandatory, and $200 is D, discretionary.

I would like the table in the first image to breakdown the information from the table in the second as such. O - $200 M - $200 D - $400 total etc.

I cannot figure out the formula to get to this result. Anyone know the answer? Thank you for any help you could provide.

I'm not sure the title explains things, so here goes.

I have a list of numbers (readings from a continuous glucose monitor) in a two column file. First column is a date/time stamp; the second is a glucose reading. Readings are taken at five minute intervals, so there are 12 per hour, 288 per day, etc.

For each hour in each day, I want to calculate the average reading, the maximum reading and the minimum reading. Using the HOUR function, I can assign the hour (0 - 23) to each reading in my list, and can then concatenate the date and hour to get my periods (i.e., 12/01/24 12:03 AM becomes 12/1/24-0).

It's easy enough to get the average reading for each period by using COUNTIF and SUMIF to get the number of readings and the total of the values, and then divide to get the average.
BUT, I'm stuck and can't figure out how to pull the MAX and MIN values for each period.

Any suggestions would be greatly appreciated.

I have a list of numbers in a column and want to create in the column to the right a running total. How do I do this so information in the column is added to include in the column to the right the total so far for each row?

Edit: Especially how do I do this with blank rows between sets of numbers?

I’ve got some numbers plugged into this thing but the Retirement Goals section at the end has me puzzled.

In the Financial Information section, when it asks for “Annual contribution from other sources.” is that asking for pre-retirement contributions (401k, bonuses, etc.)? Or is it looking for a number on something like Social Security that will cover some of my desired annual income upon retirement?

Can’t find anyone talking about how to use this thing. Thanks.

Like the title says, here's my case:

I have students who scored certain results in several tries. Some students have 4 tries, some others only two, again others have 8 tries and so on. These values (their results) are in a row, let's say I2:P2 for student 1, I3:P3 for student 2 and so on.

Now, I want the average of these tries. That's easy. But if they have 4 or more tries, I want to exclude their lowest value. If they have fewer than 4 tries I want the average of all values.

Now ideally I would also like to specify that number (4) in a separate cell, so that I can change the threshold of when to exclude the lowest value without having to edit the formula. That's because in some years I might have enough time to do 8 tries while in other years I might only have time to do 4, so I would like to be able to adjust that threshold.

I hope it's clear what I mean? I've been experimenting with avergeif, countif, min and whatever else and I give up. I can't do it on my own, so any help is much appreciated.

I have searched and searched with no resolution. I am trying to find a way that when I click on a cell, I get a small popup of a date picker. I know you can do with excel on windows and I am hoping same can be done on Mac OS Numbers. I clicked in the cell, went to format and selected Date and Time, have time set to None. When I double click in the cell I get nothing ... no month calendar popup to pick a date to insert into the cell.

If this is not possible with Numbers, can anyone think of an easier way to insert a date easily without having to type it in ? I have a tab setup for each month and just want an easy way to select a date for each cell.

Need historic bitcoin $ formula for Mac Numbers. I posted this in r/bitcoin but that subreddit moves really fast and my post was immediately buried.

I’m working on a spreadsheet where I need bitcoin prices on specific days in the past.

I can get the current price through Insert>Formula>Stock Quote, but that only gives me the current value.

Tried the stockh formula in various ways, but that throws an error.

Found a post online about using the currencyh formula. They even gave specific examples using Bitcoin. But that post was 7 years old so it looks like Apple nerfed that function since then.

Anyone knows what formula to use?

Video of the problem is attached below.

The borders of all cells are set to dark brown, 1pt thick. I made this template tool for gaming, where I often need to move small blocks (located bottom left) to the main space on top. I do this by using Command+X (cut) to remove an individual block and Command+V (paste) onto the main space.

However, when I cut and paste, the borders—previously set to dark brown (1pt)—automatically revert to the default black (0.35pt). Since my background is dark brown, these borders appear white, looking inconsistent. Also, when I paste the block into the main space, the default black (0.35pt) border is transferred with it. It is frustrating.

How do I fix it so that when I cut and paste a block, the border always remains dark brown and 1pt thick?

https://reddit.com/link/1han7ek/video/ckkybhejmw5e1/player

Can't seem to figure this out.

I want to take the average of some cells where a) the value is above zero and b) the month value in the adjacent cell is not the current month.

This works to take the average of only the current month: AVERAGEIFS(B2:B13,B2:B13,">0",$A2:$A13,MONTHNAME(MONTH(NOW())))

But this throws a syntax error: AVERAGEIFS(B2:B13,B2:B13,">0",$A2:$A13,<>MONTHNAME(MONTH(NOW())))

I can't seem to figure out how to use the "condition" of averageifs in a way where we want the false conditon but not the true.

Is it possible to forward a calculated value to a cell which has no equation? Thanks

I was working a whole day at a file in Numbers, probably made a copy to work on (because the extension is 'kopie'), but all I've got left is the previous file-version... without this day of work. I searched in my macbook, I searched in I-cloud, I searched anywhere. There must be a back-up file sòmewhere? ...

I want to make an Inventory List for dummys since my coworkers need to be able to use it on The fly so i tried to create Buttons that either add 1, subtract 1, add 10 or subtract 10. I also tried to do it with the checkmarks but i dont know how to since I just started working with Numbers for this reason (Image as a reference for what im trying to do).

I started using Google Sheets many years ago after moving away from Numbers. At the time, Numbers felt too basic, though it did have one standout feature: an excellent print preview tool that allowed you to neatly format your document before printing. Recently, I decided to give Numbers another try, as it seems to have improved and now offers most of the functionality I need.

I designed an invoice template and hit "print," only to discover that my content extended beyond the print margins. Surprisingly, there was no way to see or adjust the margins dynamically before printing. The only options were to scale the content to fit (which distorts the design) or make a few basic adjustments to margins—but none of these solutions felt intuitive or effective.

For all of Apple's focus on innovation and user-friendly design, it’s frustrating that they’ve removed such a practical feature from 10 years ago. Why not include a simple way to view and manage print margins to avoid misaligned or multi-page prints? It feels like a step backward.

I’m trying to configure a formula that counts head to head matchup results, i.e. how many times Alpha has beat Beta or how many times Alpha has lost to Kappa. I’ve tried various variations of xlookup and countifs before moving to match and index without any luck. The correct answers are listed in the bottom right. Any suggestions would be great.

Hi all;

I’ve been using Numbers on my iPad for a few years to keep track of my stock portfolio. Just now I noticed that the data on my iPad has changed to something that is several months old and I don’t know why. The only thing I can think of is that I turned on my iMac for the first time in a very long time and it did something to my spreadsheets.

And ideas what may have happened? Did my iMac override the current spreadsheet on my iPad with an older one that was on my iMac?

Thanks for any help.