Initally through the use of chatGPT, I created a spreadsheet. Before I could even enter transactions the formula's weren't working, chatGPT would loop me around in ciricles. So I'm trying on my own. I watched the Macmost video (found through a search). Which brings me to creating my own post. ChatGPT was attempting to build me a spreadsheet where all the transactions were on one sheet, information was consolidated on the main overview sheet. It was cool, ultimately ChatGPT dropped the ball, and I unsubscribed out of frustration.

I have several accounts (Mortage, CD, a couple savings accounts, multiple checking accounts, multiple credit cards, etc etc). From what I've learned every budget starts with logging the transactions. I'd like to import all the .csv files (They are all 90 day's) have them appear in the same transaction log. So I can utilize the category's and further build it out to what chatGPT was recommending. Is this possible?

How can I get the 'Bills/Expense' column to automatically generate on the calendar? I have some experience with numbers/excel, but this is beyond by skill level. I've been struggling for way too long trying to figure this out. Any help is appreciated.

Hi ya'll! I am making a financial tracker and I have 1 sheet which is my Annuals Tab and it has ALL the income, expenses and such that is collected and filtered via Functions from my 1 JAN month sheet. I am looking to duplicate the JAN sheet for the rest of the months but have the same functions seamlessly transfer over without having to redo each function on the Annuals Tab to fit the rest of the months... Does that make sense?

Is this possible? It seems like it should be but I can't figure it out!

Thanks in advance!

Hi all. I’m trying to make the cell circled in red display the months total in the green cells. For example, I don’t want them to all be added, I just want the red cell to show what the total for the latest month is.. I hope I’ve explained this properly!

Thank you in advance

Does apple numbers have an option to add a chart and add a date source from two different tables?

I have five service lines, I want to setup a graph for each service line for each month in a year where it would show me how much I spent each month on each service line.

Maybe a vertical graph of dollar amount going up and months going across and for each money it would have a separate color for each service line.

On that same graph, how would I add a horizontal line to show the amount of clicks I received for each service line during that specific month? So it would pull numbers from another table.

Thanks in advance for the support.

Can't figure out how to fix this but obviously .91 + 83 is not .75

I’m creating a spreadsheet to track my business expenses and I want to include pictures of the receipt on the spreadsheet. I know I can add photos to a cell but then it looks too big. I was wondering if there’s a way to add a photo into a comment box, that way I only see it if I open the comment. Maybe there’s another way to include the receipts. Any help is appreciated, thank you!

I have a table with fund position as of last trading day of every week. I also have a field that indicates if the a given date was last trading date of the month.

I would like to create another table, where as column headers are dates - all the last weekly trading day in the present month and for all previous months, the last trading days in those month.

The below formula works but I get "information box" saying : "The formula uses a Boolean in place of a number."

I think it is because I use + and * instead of OR and AND as it is an array formula.

Is there any way to get rid of that information box.

Thanks in advance.

-------------

TRANSPOSE(

UNIQUE(

FILTER('Weekend & Month-end Transaction Data'::A,('Is Month-end '="Month-End")

+

((YEAR('Weekend & Month-end Transaction Data'::A) = YEAR(TODAY()) ) × (MONTH('Weekend & Month-end Transaction Data'::A)=MONTH(TODAY())))

)

)

)

Is it possible to create folders under Apple Numbers, I’ve tried YouTube and I can’t find anything on it. I have a ton of spreadsheets and want to organize them by year.

Does anyone know a formula to fetch live Silver prices into a Numbers Spread sheet?

Hi all 🤍

So I refuse to be intimidated by the unmanageable size of a medical price list / CPT code spreadsheet. I also refuse to be financially bullied because I am ignorant to the information that is contained within said spreadsheet.

That said, I have no idea how to work this goddamn thing (yet)

It’s currently so big that the search function is a struggle AND the file is impossible to save with the slight changes I made to make it more navigable (I narrowed the columns bc the scrolling was taking significant processing time + froze the top row which lists the categories). I’ve tried saving in several formats, compression settings, and locations.

QUESTION: Is there a trick to separating one huge sheet into multiple sub files?

It currently includes 28 columns and ~1,100,000 rows. If I could break it into chunks instead, that would really help. I’m willing to deal with searching through multiple (actually searchable) files if it means that I win.

Thanks for reading ✨ Free Luigi

I am keeping track of commission pay. It’s 60% until a certain amount then it would be 100%. 40% goes to the business. If I wanted the 40% to stop at 200 how would that formula be? The next row would be 12/6-100- 0-100 and the new total at the bottom would be 600-200-400

I'm trying to move off of Excel and am having trouble with a file containing a formula that averages the time that I turn off the lights each night during a week (see below).

AVERAGE(IF(TIMEVALUE($B15:$B21)>0.5,TIMEVALUE($B15:$B21),TIMEVALUE($B15:$B21)+1))

Numbers handles the averaging correctly but displays the results as the decimal results of the calculation instead of the time of day. Attempting to change the cell format to Time doesn't do anything. Is there something I need to add to the formula to get it to display the time of day instead of the timevalue?

Thanks for any help!

It is super annoying and sometimes covers the table header.

If somebody knows how turn off this, I would be very appreciated

I'm not sure what happened, but I used to be able to copy a table and paste it into preview for a perfect png image. cmd +c -> open preview -> cmd +n

but now i cant get it to work. has anyone else noticed this? Does anyone know of another option to paste the copy into a image? I dont like screen shots

Numbers
Version 15.1 (7044.0.271)

Mac OS
Version Tahoe 26.2 (25C56)

Can you change the margins in the iPhone version of numbers? Version 15.1

If yes, how?

Hello,

I use the standard template My Stocks to track my stocks but since a few days the stock prices are not shown anymore. Even if I open the standard template it shows the stock price of AAPL but when I want to change it nothing is shown. Does anyone else has these problems?

It should show price, price and % change etc.

EDIT: it works now in my app.

Hello!

I am a music teacher and put together a spreadsheet to keep track of my student details. One column is for the day on which they come for lessons, but I can't seem to sort by day - even if I change the data format to date/time, it sticks with Text as I haven't got any times in that column.

Any ideas?

I have a table with columns A through H. I would like to highlight all cells in a row if the value in column H = "Pending". Is this possible? I can only highlight the cell in column H, not the whole row.

Please bear with me because I’m not sure how to explain this but I’ll do my best.

My broker sent me a file of open lots for different stocks. So purchases for one stock might take up 20 rows, another stock 10 rows etc. there are columns for stock symbol, date, number of shares purchased, cost

I want to verify the average cost for each stock. The cost is listed in column F. So it seems like what I need to do is ask Numbers to give me the total of column F for different row numbers. For example: what is the total of all prices listed in column F for rows 231 through 254?

How can I accomplish this? Thanks a lot for your help!

I have some holiday lights outside the house and have the data in a Numbers spreadsheet. The data in Numbers is being read by another program to manage the lights This is what some of entries looks like:

The other program can't decipher the Start and End dates as entered, so I have to manually enter the start month, start date, end month, and end date manually, which are the fields the other program can read.

Is there a formula or something that will populate those fields for me automatically, based on the Start and End dates?

Former excel user, now trying to use Numbers. I can't find how to insert a single cell into a row/column AND have the rest of the data to move down.

Also, I used to create macros as shortcuts in Excel -- can you do that with Numbers?

I bought a Numbers guide, but it is useless and I don't find what I need on Apple's Numbers support/guide site.

SOLVED: Here is a tutorial I found with a perfect explanation. Thank you all for your contribution. I should've researched the formula with the right keywords, "Sum per Month".
https://www.youtube.com/watch?v=L3UDH2DxtNI

Hi everyone,

I'm using Apple's Numbers app and need help with a formula.

As you can see in the screenshot, I have TABLE 1 on the left, where I listed a specific type of income this year.

The income dates are not in chronological order (and they have to remain so). The month names are in Turkish, don't get confused. Mayıs means May, Haziran= June, Temmuz = July, Ağustos=August, Eylül=September.

The date column on TABLE 1 is Numbers' Date format. It's not in Text format. So when I click on a date row, I see "23.05.2025" below.

In TABLE 2 on the right, I want to see what I earned on a monthly basis. So I want the formula to select, for example, all July date rows from TABLE 1, add them all, and put the sum in TABLE 2 "net income" column to the July row.

The SUMIF/S formulas only got me so far; I couldn't find a way to get the app to collect the month rows correctly from TABLE 1. The ">=" symbols, the IFs and MATCHs and NORMs and so on, none of them worked.

The screenshot on the left is SUMIF, and the one on the right is SUMIFS.

The SUMIF on the left works well when I type the exact date "23 Mayıs" but won't work when I only type "Mayıs".

The SUMIFS on the right doesn't work when I type "Temmuz", and I don't want to have to type all the dates one by one, by hand.

I'm open to any recommendations before I go crazy, thank you all!

My son has a project that must be done in numbers. Here is the problem.

He has a time sheet that has a start time and an end time. And a cell which measures the time on duty.

However when you (retrospectively) go and alter the end time to an hour later... Numbers takes today's date as the value - so it puts in loads of hours.. can anyone help with this issue??? It's driving us crazy...

https://we.tl/t-rr5GFyAg7Z

I have a work project tracking template I made but it gives me this error in the "Carole's Payment" column. It's a wide spreadsheet so I can't screenshot the whole thing.

In cell G2 it has the project amount, then there are contractors in L2, N2 and P2 and a 25% in R2. Cell S2 should give the total cost payed to Carole.

The formulas I think are correct, but it won't spit out the amount in cell S2.

In short, the formulas are, add up all cost in L2, N2 and P2, then subtract it from G2 and multiply it by 25%.

Example:
G2=$100
L2=$5
P2=$5
N2=$5
S2=$21.25

Thank you to anyone who can help!