Questions tagged [numbers]
Apple Numbers is an application for creating spreadsheets and graphs. Use this tag for all versions of this app, web based, iPad and iPhone as well as macOS
696
questions
0
votes
1
answer
28
views
How do you make the x-value of a Numbers graph start with a number that is not 0 -- repeat question, but for 2d bar chart
the question was already asked, with a great response, BUT I'm trying to use a 2d bar chart, and the Scale Max / Min is locked with 'auto'
QUESTION & ANSWER
1
vote
2
answers
98
views
Convert a string of numeric calculations to numeric value in Numbers
I have a string of a numeric calculation in one cell. The input for the cell is ="1+2+3". So the cell is displayed like this:
Column A
1+2+3
How can I get the numeric outcome of the ...
- 21
1
vote
1
answer
110
views
How to get quotes for certain currency pairs into Numbers using a function
The pictures don't show the ⚠️ for errors but each blank cell is an error that reads something like:
There is no historical data on the requested date. The next available is on 8/7/2827673.
The ...
- 13
1
vote
1
answer
35
views
Need Help With Formula For Rent Ledger
I have a rent ledger sheet that lists all the rent due dates (Column A) and amounts (Columns B & C) both past and future as shown below.
Each month there are two payments due, Column B is due on ...
0
votes
1
answer
35
views
Trouble creating line graph on numbers with multiple variables
I have little to no knowledge when it comes to Numbers/other data programmes. I’m working with a client and I want to create a line graph to show how these variables affect each other (eg. Does food ...
0
votes
1
answer
38
views
How to convert any duration to days in Numbers?
I have something like this
Start time (A)
End time (B)
Time passed (C)
Units done (D)
How many units per 24h (E)
08:25
15:40
7h15m
43
???
I can manually calculate that 7h15m = 26 100 seconds. 26 ...
- 3,236
1
vote
2
answers
74
views
Problem using Numbers Regex.Extract function
I need help with the following Apple Numbers REGEX.EXTRACT formula that doesn’t return the word before a dot. Below are the text form of the arguments passed to the formula and the formula itself as ...
- 11
0
votes
0
answers
67
views
Opening older Numbers files
I am running Monterey, with Numbers version 11.2. I have some old spreadsheets that I created in Numbers circa 2011. I tried to open them and received the error message: "[filename].numbers can't ...
- 145
0
votes
0
answers
29
views
Adding value to a cell in Numbers for Mac when a value already exists
I have some data points in column A that I want to add 50 to across all cells in that column. How can I calculate that per cell without having to manually add 50 to every value?
0
votes
0
answers
6
views
Aggregate operations on filtered rows
How do I perform aggregate functions on rows displayed after I filter a column? For example, if I wanted to append a row after the filtered rows that are displayed, and in that new row, have a sum of ...
- 317
0
votes
0
answers
38
views
List all comments in a Numbers document?
I am working on a Numbers document that has a lot of comments. I know I can look at the individual comments, but is there any way to get a list of all the comments in the document? I'm probably ...
- 277
0
votes
1
answer
37
views
my numbers spreadsheet is all screwed up and I can't figure out why or how to fix it
It is as if my spreadsheet is overlapping itself...
What is going on?! how do I fix this?
- 293
0
votes
1
answer
254
views
Basic use of SUMIF in Numbers app?
How does one write a simple SUMIF formula in Apple Numbers app, version 13?
For example…
In this example, I want to write two SUMIF formulas in two cells:
The sum of numbers in the entire second ...
- 12.1k
0
votes
0
answers
20
views
Numbers default to open TSV/CSV files as Windows Latin 1. How can I change that to unicode?
Desktop-Numbers on Ventura defaults to open TSV/CSV files as Windows Latin 1/1252. How can I change that to unicode?
I tried adding a magic number in the beginning of the file (I am building the file ...
- 3,236
0
votes
0
answers
45
views
Import CSV/TSV into plain sheet in Numbers?
When I open a CSV/TSV in numbers it is imported into the default template, where the first row and the A-column are "headers". Most of the time I open such files the first row and A-column ...
- 3,236
1
vote
0
answers
27
views
Cmd+x halting the OSX keyboard
I have run into a very weird problem and any insight into this would be much appreciated. I noticed for the past two days whenever I press the cmd + x keys into the keyboard to cut an entry in the ...
- 51
0
votes
0
answers
16
views
Can two or more separate Numbers spreadsheets (not sheets) interact?
I have two separate spreadsheets.
On one, I have the accounting and calculations for my business.
On the other, I have what I call Daily compensation sheets.
My employees use these compensation ...
1
vote
0
answers
21
views
Chart autoscale major step logic in Apple Numbers
Does anyone understand the logic used by the chart autoscaler in Apple Numbers to set the number of major steps in the Y axis of the chart? I am not looking to alter the major steps in settings. I ...
- 51
0
votes
1
answer
44
views
To sort a table with linked data
There is a Numbers document with 3 sheets: first (2 columns), second (1 column), and third (1 column).
second:
sun
grass
sea
third:
yellow
green
blue
first:
Column A | Column B
=second::...
- 77
2
votes
1
answer
304
views
Opening CSV in Numbers does not display decimal numbers correctly
Lets say I have following CSV file:
1.0;0.125;0.1253
Opening it in Numbers gives me:
Why are 1.0 and 0.1253 correctly presented as "1.0" and "0.1253", but "0.125" is ...
- 161
1
vote
1
answer
57
views
Formatting Numbers conditions for SUMIFS
I have a SUMIFS that gets the desired result. But the condition is formatted as a string, in this case a date comparison, "<=2023-03-21". The date is located in cell B2. How can I rewrite ...
- 2,206
0
votes
0
answers
36
views
What template on numbers spreadsheet is suitable for the following need?
Using Numbers spreadsheet on iPhone, what template is suitable for the following need?
I want to follow the gaps between events occurring once a month on different dates, after inserting them into the ...
5
votes
1
answer
482
views
How do I get Dark Mode on Apple's Numbers
How do you get Numbers to be in Dark Mode. (The OS itself is in Dark Mode)
You can change the background of the spreadsheet buy use of Format Text
But how do you get the surrounds to be white on black ...
- 29.7k
0
votes
1
answer
104
views
Numbers: Get max value and the value's date
I have a document where one column is a date and another is a value for the date. I'd like to be able to get the maximum value and the date when that value appeared. For example if I had
A (Date)
B (...
- 2,206
0
votes
0
answers
53
views
Timestamps in Numbers are only partially recognized as time?
I have a column with timestamps minutes, seconds and milliseconds. Originally they looked like this
6:24,120 (it is output from the time command)
Pasting it into Numbers causes weird results. I can ...
- 3,236
1
vote
0
answers
46
views
How to move an equation in a diagram in iWork Numbers?
I have a diagram in macOS Numbers 12.2.1 with two trendlines where I also inserted the equation for each trendline. The problem is that those two equations are on top of each other and I can't find a ...
- 3,236
1
vote
0
answers
110
views
Font size in Apple Numbers, Excel and LibreOffice Calc
See the screenshot below. The same font & size with zoom level 100% has different visual sizes in these three macOS spreadsheet apps:
Apple Numbers v12.2 (left)
Microsoft Excel for Mac v16.69.1 (...
- 111
0
votes
1
answer
64
views
How to add up multiple values per row in Numbers using SUMIF?
I would like to use a formula to add the values from columns B,C and D for all rows where checkbox A is set.
In this example, this would be 1+5+9+3+7+11 = 36.
Unfortunately, my attempts like
SUMIF(A;...
- 103
0
votes
1
answer
31
views
Is it possible to have multiple values in a cell
I have a Column called "Genre" where it should be different TV show genres, but as you all might know these could be multiple. Like Drama, Comedy and so forth.
When filtering for Comedy I ...
- 1
2
votes
1
answer
566
views
Trying to catalog my movie collection into Numbers app and "48 hours" becomes "2d"
I can type into a cell "40 year old virgin" but I can't put in "48 hours" as it gets changed to "2d".
What nonsensical setting is making this happen?
Also if I type in &...
- 293
1
vote
1
answer
26
views
Numbers Mac Link Date Cells
I would like to link cells formatted as dates together so that I can change the date in one cell and have all the dates change to go in order from that date. So if I format the cells to go from Jan 1 ...
- 11
1
vote
0
answers
342
views
Numbers.app Pop-Up Menu from Column?
I need to automate the following somehow, and I want to know if it's something that the software can accomplish:
I need to set a field in a table to a Pop-Up Menu, that is made up of entries in a ...
- 261
1
vote
0
answers
36
views
How do I stick a graphic to a frozen header column in Apple Numbers?
I want to paste a graphic on a frozen header column, and have it frozen to the header column when I scroll the rest of the table.
But when I paste the graphic over the frozen header column and scroll ...
- 579
1
vote
1
answer
89
views
Numbers not sorting names correctly
For some reason I’m having issues sorting column D. When I tap “Sort Ascending” it sorts everything correctly except books 5 and 7:
“12, 13, 14, 15 16 17, 18, 22, 23, 5, 7”
I’ve tried deleting all the ...
- 173
2
votes
1
answer
448
views
How to have Numbers automatically sort descending?
I’m trying to make my own Sports latter in iPadOS Numbers. I have noticed that there’s an option to sort cells by ascending or descending but I have to click on that option every time I want to update ...
- 173
0
votes
0
answers
237
views
Numbers: Combine several tables into one
I have a Numbers spreadsheet with a table for each room in our house listing jobs that need doing and a priority rating for each. For example:
Kitchen
Job Priority
Fix tap ...
- 101
0
votes
0
answers
24
views
Numbers Formula: iPad (Main), MacBook Pro
Any IF formula to move a ROW of information to another page if the checkbox is unticked in that specific ROW?
This is for a retail shirt orders status spreadsheet using ‘Numbers’
Thank you!
- 1
0
votes
0
answers
21
views
NUMBERS- sheet export based on selected data
Hey,
I need some help.
I have a large dataset with the following columns (system/subsystem/hazard identification/risk estimation/safety measures). The image below is not in English, but hopefully it ...
0
votes
2
answers
39
views
NUMBERS- write text based on two checkboxes
I would like to have a function tied to two checkboxes.
checkbox.....YES - NO
checkbox.....YES - NO
Result in a cell based on the combination:
1).................2).........output in a separate cell
...
0
votes
0
answers
9
views
Numbers: Plot a point on a line
Is there a way in Numbers to take a cell value and plot in on a point on a line?
I am creating a prioritization table where the user selects the cell values from sliders and drop downs. These cell ...
- 101
0
votes
1
answer
83
views
Counting the number of remaining weeks in Numbers
I'd like to be able to calculate how many weeks from a given date in the future until today are available. But I can't find out how to do this. I found WEEKNUM, but that only gives me the calendar ...
- 125
1
vote
2
answers
80
views
how do you disable sorting in Numbers app?
I created a document, entered data like:
abc | 1
xyz | 4
ghi | 2
...
Then I sorted by name...
abc | 1
ghi | 2
xyz | 4
... then I said, ok cool.. I want to temporarily turn off sorting so I can go ...
- 293
0
votes
1
answer
33
views
Numbers: Can you write text to a cell with a formula?
I want to do a conditional check in a cell and write text to a separate cell on the results.
So, in F1, I would have this formula:
IF((A2)=(A1),(G1)="duplicate", (G1)="")
but I ...
- 101
1
vote
1
answer
1k
views
In Mac Numbers is there a way to change the cell fill color depending on a match in different sheet?
I want to change the cell fill color on one sheet depending if there is a match of information from another sheet. Here is what I am looking for:
If the P# in Sheet 1 matches the P# in Sheet 2 I want ...
1
vote
1
answer
617
views
Can I loop an automator task for each file in a folder?
I have been tasked with converting lots of .numbers files to .pdf. Having exported manually did not satisfy me, obviously, so I dug around online and found an automator script (below). It obviously is ...
- 11
0
votes
1
answer
62
views
Numbers.app Chart Trendline Equation Capture
I have a set of data that creates a chart. It's a growth chart. I the chart to display the Trendline.
y = 55x - 1234
Is there a formula that captures that equation? Having to re-enter those values ...
- 261
1
vote
0
answers
30
views
MacOS 12.6 Numbers version 12.1 (7034.0.86) Day function in vlookup function
I am attempting to use the calendar spreadsheet provide as a template with Numbers. In the month section there are dates in the even rows and large cells in the corresponding odd rows for whatever ...
- 11
0
votes
1
answer
112
views
Numbers.app or Excel: How to include cell bg color info as part of a CSV export?
I have a complex Numbers.app spreadsheet which contains a table with cells that are colored with different background colors. The different colors represent essential information.
When I export the ...
- 2,167
2
votes
2
answers
324
views
Using ROUND in IF in Numbers
I am using Numbers to track changes of time. I am using an IF() to show an upwards / downwards trend and there is an if that checks if there was any change at all. But I the calculation seems to be a ...
- 125
1
vote
1
answer
4k
views
Apple Numbers : remove rows with blank cells
I have a tables with some rows with empty cells. I want to remove those rows.
In Excel I can use the "Go To..." command to select blank cells and then i can delete the rows manually. (see ...
- 395