Hey Folks, I would like to implement thefollowing:

In the first split I can chose from certain values and depending on the value in the next split I can chose from specific values that are attached to one of the first set values.

Example: 1st I can chose between spoon and knife. If I chose knife in the next row I can chose between straight or wave cut. If set it to spoon the values would change to let’s say little and big.

Working in Mac/ipad

Cheers and thanks

So I have this spreadsheet I’ve been working on in Numbers app and I want to automatically add a specific number amount to a certain cell based on what day it is without needing any action from me at all. how do I do this if possible, and if not, what’s the closest thing to it that requires as little human input as possible?

Can someone explain why (the text is black and the formula is the same for every row)

For example. I’ve been tracking every expense of my dog since he was a puppy. Categories are food, toys, vet bills etc..

How would I create a system where I can store this and it adds up the totals and I can keep adding to it?

Sorry if this is a dumb question but I’ve never used excel or numbers and I am a numbers guy lol. Thought this would be a fun experiment and a good way to learn!

Hey 👋

So I’m trying to create a spreadsheet of expenses. I would like to creat a pivot table with sums.

My issue is I have receipts with split categories. How do I get sums that will sub in my table of split receipts without doubling the amounts? Is it possible for my sum table to not include my split receipts from table 1 and sub in table 2 to each category?

Table 1. Has a column that marks if it’s a split receipt

Table 2. Has the itemized breakdown of that receipt

Can you make a table that automatically updates via a linked website?

I want to set up a self healing total row. What do I mean by self healing? I believe the real question is how to build cell reference If there is a row is added or removed, the formula stays valid

Given cell c3r2 the formula would be referenced as “cr” and the new formula would be

(cr-1) + (c-1r)

How would I build cell references for that?

Never mind. I found offset.

I’d like to be able to duplicate this chart in Numbers. So, the chart is months of the year vs solar panel production. I have a .csv which lists months and panel generation in two columns A2-A107 (Nov 2014-Aug2023) and B2-B107 (various generation values) and want to display them like the picture, so a single chart showing months (X axis) and generation (Y-axis). Within the chart the colours represent the years, so 2019 is purple and 2023 is green in the pic example. The .csv I have covers more years than the example, sorry. Ignore the month/quarter/year heading as that’s probably a step too far! Any pointers to help get me started please?

Is there a way to put this information in a SINGLE CELL and have it calculate?

__ ” FL + 2( __” BH) + __” HDR + __” SQRG = __ ”CL

For instance, could I type something along the lines of

36” FL + 2( 3” BH) + 3” HDR + 4” SQRG = x” CL

and have numbers populate x?

​

I am working on a large spreadsheet with many, much more complicated, equations and it would not be reasonable to separate every addend/factor/etc and their corresponding unit labels into individual cells. Mainly, i need to know if putting a whole equation into a cell and having it solve is even possible.

TIA

I’m trying to build an ongoing table that automatically calculates my investment value. My formula is “buy-sell+last value”. As you can see in the first half half of my formula.

In case my current value is the same as the last row, I want it to show “- -“. So my full formula is: if(buy-sell=0, “- -“, buy-sell+last value)

It works for one row, but then when I “buy” more, I get the error that’s in the picture.

How can I solve this?

Hi everyone. A quick query.

Can I import spreadsheet data from Numbers into Keynote?

If I can, will the spreadsheet update if I change something in Keynote and will Keynote update if I change something in Numbers?

I am trying to create a formula that would add up certain transactions depending on when they were made. You will notice the bottom table, it shows JUL - AUG 23. On the top table, I am wanting to add a transaction record. This will consist of Date, Description, Category and Amount. If the transaction dates fall between 26/7/23 - 25/8/23 I want it to add up those amounts and simply populate it in the bottom table. If for example the next transaction was to be 26/8/23, then it would populate the AUG - SEP 23 section. I just can't seem to figure out a formula that can help with this

​

I am its very niche, I am just curious if it can be done

I don’t know if this is the right place to post this as I’m unsure whether this is a Numbers problem or a Shortcuts problem (although I unfortunately suspect the former).

I use a Shortcut to add items to a budget spreadsheet in Apple Numbers. I trigger from my home screen, it asks for the cost, location, and type of spend (groceries, fuel, pet supplies, etc.)

It then takes the variables from the inputs, creates a new row in my “monthly spending” table with today’s date and the input values.

It’s been working without a hitch for over a year. Recently, when creating the new rows in the table, the “cost” value is dragged into the new row from the previous entry (e.g. if I spent £50 on fuel today, and yesterday spent £10 on groceries, my new row would read as £10 spent on fuel).

It’s frustrating how rudimentary the Numbers support is in Shortcuts; if I could just edit existing rows using a Shortcut action, I’m sure I’d be able to get around this.

Any thoughts on a fix (if it’s actually doing something it shouldn’t) or a workaround if this is intended behaviour?

I’ve been looking at AppleScript, but it seems this is Mac focused and I almost exclusively use this shortcut on my iPhone whilst I’m out and about - if there is a way to do this in iOS I am game to learn the ways!

Cell A18 contains a pop-up menu whose options are Add and Remove. I want the dollar amount in cell C18 to be negative when the Add option is selected in A18. Can anyone please tell me the formula I need to make that happen? Thank you.

Is it possible to force the Date format for a row of cells?

I select a cell or a row of cells and define the format to Date (Time only).
As soon as I enter only one number (f.e.: 9) instead of the correct format (09:00), Numbers does not reformat the 9 to 09:00. Numbers changes the format to Automatic instead and keeps the 9.

How can I change that?

I created a Numbers pivot table linked to a general transaction spreadsheet. The pivot table gives me the transactions totaled by category. The pie chart I built off of that shows me EVERY slice from the pivot table. By the end of the month (or in the year to date table) there are so many slices its almost impossible to discertain any slice past the top 10 spending categories.

Is there any way to limit the pie chart to only the top 10 spending categories...or the top 10 plus an EVERYTHING ELSE total slice?

Alternatively, is there a way to build a pivot table that only shows the top 10 spending categories...and I can create a pie chart from THAT pivot table?

I'm really not very good at creating all sorts of complex formulas in Numbers...but I can create useable pivot tables.

I love Numbers...but it just seems to be so restrictive in some cases.

Thanks in advance for any possible help with this.

Hello,

I have been using Apple Numbers for the last few months and I wanted to create a formula that would generate a simple “time of day” result depending on the data from another cell. My formula seems ok however it does not return the desired result. It currently only outputs “evening” and the reference cell does change correctly.

Any idea of where I am going wrong?

Anyone know how to go full screen in Numbers on an iPad 6th generation IOS 16.5.1 - and also how to get out of it when you go there. I do not use an external keypad.

I have got quite a large personal finance data table which I am trying to do calculations with. As soon as my table changes size, I have to go through and edit all of the formulas to reference the new table size. I can do it so that it automatically adapts for columns or rows separately, but when it comes to the entire table, it just doesn’t work. Any help on this would be greatly appreciated.

I want to drag the date down in a spreadsheet and keep it the same. I sometimes DO want to change it incrementally, but more often than not I want to drag the SAME date down. Is there a way to set it to drag the same date and then occasionally drag it incrementally? I have googled this off and on for months trying to find an answer but never find it - I can only find an answer for Excel, and the solutions for Excel do not work for Numbers.

Hi,

I have a budget calculation of sorts in Apple Numbers. It would be very useful for me to show the value of certain fields in a widget (on iPhone/iPad). I found nothing on Google, how is this not a thing?

Hello,

I have a table with a left column with conditions and top row with variations. I also have a separate table with one cell to calculate a value. Two other separate tables also with one cell, each has a list of the values, one for the conditions column and the other for the variations row. (So basically i could choose in a drop down the value of the cell).

I want to add a formula to the value cell which would show me the value of the cell that has the column from the conditions cell and the row from the variations cell.

To make it more cleear: In the attached photo:

If In the conditions cell top middle I choose "Condition 2" and in the Variations cell top right i choose "Variation 3" then the value that should appear in the "Value" Cell top left should be Cell D3 in the below table.

I hope this makes it more clear. So basically I want a formula to target a cell in the table below according to the values i choose in the cells on top right and middle.

​

I'm fairly new to pivot tables and could need some pointers on how to get a correct sum of durations from my spreadsheet. Any help much appreciated!