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

Filter by
Sorted by
Tagged with
0 votes
0 answers
11 views

How can images be bulk inserted into Numbers, each one on a new row

I want to insert about 170 images into Numbers, with one image per row. CopyPaste only pastes the file names from Finder. Dragging and dropping the selected files from Finder puts them all in one cell....
user avatar
  • 187
0 votes
0 answers
7 views

Help using AppleScript to copy cell data IF another cell is true

Using Numbers, I'm attempting to copy the text in numbers to a different app but it's conditional. For example, cell B10 must have the text "Invoice" in the cell in order for me to copy cell ...
user avatar
  • 1
0 votes
0 answers
28 views

Numbers: How do I refer entire rows in different sheets?

I am trying to create a table that contains all entries from other sheets in the numbers file. In all of these other sheets, the structure will be identical. The reason for why I do this, is because ...
user avatar
0 votes
1 answer
74 views

Mass Convert Numbers to CSV/Excel (Watch me do)

We have a department that has been using a copy of an Apple Numbers file to input daily data into and save them daily. The numbers file is designed with multiple tables etc. - but they have the same ...
user avatar
0 votes
1 answer
36 views

Dynamic reference to a cell from another sheet based on text

I am trying to learn how to refer "dynamically" to a cell from another sheet given a textual condition. I have the following scenario: Example There are two sheets labelled "A" and ...
user avatar
0 votes
0 answers
16 views

How to have one cell’s rules affect another cell

I would like to change the info in one cell and have it change another cell at the same time. For example, if one cell has a certain value it changes the conditional highlighting of a cell next to it. ...
user avatar
0 votes
1 answer
21 views

After opening a .doc/.docx, I would like to save the converted .pages in same folder as .doc was opened. Does anyone know an easy way to do this?

This drives me crazy. What I usually do is drag the original folder location temporarily into the Finder Sidebar so I'm quickly able to find it in the save dialog. Hopefully there is a setting or ...
user avatar
0 votes
1 answer
29 views

Automatically Turn Cell Into Formulas in Numbers

I'd like to know if it's possible to automatically turn a column of cell data into individual functions. Here is an example what I'm working with. Instead of having to edit each dark grey cell ...
user avatar
1 vote
1 answer
75 views

Add a little spreadsheet into Pages app document

Can I have a little spreadsheet within my Pages document, do a little bit of calculations? I found the "Table" feature. But that seems to support only static content, not formulas for ...
user avatar
1 vote
1 answer
164 views

How to create a URL link in Numbers from a CSV file

I have a CSV file that I open in Numbers, I need one of the cells to be a URL clickable link though, and in the CSV file if I use something like this, it does not turn into a clickable link in Numbers:...
user avatar
0 votes
1 answer
26 views

In Numbers, how to do dates with weekdays in rows with mouse cell dragging?

In the first row in Numbers sheet I would like to show all the days of a couple of months in this format (the same format as the date in macOS top panel): | Fri 1 Apr | Sat 2 Apr | Sun 3 Apr | ... So,...
user avatar
  • 85
0 votes
1 answer
31 views

How do you make the x-value of a Numbers graph start with a number that is not 0

The simple question is, how do you make the x-value of a Numbers graph start with a number that is not 0. The x-axis of my graph is time, and it starts with 30 seconds, but the graph that numbers ...
user avatar
  • 103
0 votes
1 answer
50 views

Is there a way to convert a formatted duration value into a text value?

I am trying to convert duration values into the specific format I need for subtitle timings: 00:00:00,000 - leading zeroes for hour, minute and second, and a comma separating seconds and milliseconds ...
user avatar
0 votes
1 answer
58 views

How do I get rid of "The formula uses a Boolean in place of a number"?

I'm using a formula to convert stone and lbs to lbs only. Here is the formula that I am using: INT(B13)×14+IF(INT(B13)≠B13,(B13−INT(B13))×10^(LEN(B13)−FIND(".",B13))) My stone and lbs are ...
user avatar
  • 15
0 votes
0 answers
29 views

Apple numbers Formula based on pop-up menu choice

I’m trying to find out if I can alter an existing formula depending on which pop up is chosen? I am hitting a wall searching online. I created a spreadsheet for tracking online sales with a formula ...
user avatar
0 votes
1 answer
44 views

How to find merged cells in Numbers?

I wish to filter a (long) Numbers sheet, but Numbers displays the message Filters are unavailable the table contains merged cells How can I find these merged cells without clicking unmerge cells? ...
user avatar
1 vote
1 answer
69 views

How can I have Numbers autofill interpolated values between two cells?

How can I have Numbers autofill interpolated values in a range of selected cells (from the value of the first cell to the value of the last cell)? I know how to do this with a formula but it's too ...
user avatar
  • 11
0 votes
1 answer
30 views

How can I return a value from column C based on a match in column A, and a maximum value within the matched rows from column B?

I have a Numbers sheet for tracking work on podcast editing. The source table includes columns for the episode name, the work start and end times, a work duration calculated from those two, and the ...
user avatar
0 votes
0 answers
33 views

Scrollable table within a sheet in Numbers?

I'm using Numbers and have a second sheet on the right hand side that I'm using for a log. This is a single column with just dated text entries in it. This is going to get quite long, a lot longer ...
user avatar
  • 504
0 votes
0 answers
8 views

Differentiate column in numbers

I have a column in Numbers that has some elements, say [1,2,2,4,10] I'd like to make a new column that has the difference between those elements, [1,0,2,6]. How do I do that??
user avatar
  • 1
0 votes
1 answer
73 views

How to edit a cell title / label in Numbers?

I started a new sheet using the "Simple Budget" template on the Mac. I edited the text values of the cells and changed the numbers' column format to be just Number. All good but when I ...
user avatar
  • 216
0 votes
2 answers
78 views

How to add (or perform a different function to) multiple numbers in a single cell separated by semicolons in Apple Numbers?

I would like to add up (and do other functions) to multiple numbers in a single cell separated by semicolons. The idea is that I have multiple values (e.g. „15; 20; 25; 25“) logged in a cell and want ...
user avatar
0 votes
0 answers
24 views

Numbers : paste and create rows

I am new to numbers, sorry about it. I would like to paste 100 lines on a new numbers sheets. 100 lines from other application. In excel, it creates 100 rows. In numbers, rows are truncated... I dont ...
user avatar
0 votes
0 answers
36 views

AppleScript cannot export to desktop but can export to home

In the following script, if I change desktop folder to home folder the script executes but the resulting folder is in ./Library/Containers/com.apple.iWork.Numbers/Data/Crypto Prices tell application &...
user avatar
  • 409
0 votes
1 answer
26 views

How can I make a column reference a row in another table?

I have this table that was created by using the "Form sheet" on iPad Table A ------------------------------------- Month | Rent | Groceries | Netflix | January | 100 | 100 | 100 ...
user avatar
0 votes
2 answers
225 views

Using AppleScript, how does one create a clickable link to a web site in a Numbers cell?

I am doing some automation work using Numbers to track web page views. My test script is something like the following: set myURL to "https://mywebpage.com" tell application "Numbers&...
user avatar
0 votes
0 answers
16 views

Trying to chart the y axis in Numbers to be confined to one 24-hour period

Greetings — When I try to do this (should be easy enough), the default values span more than 24 hours on the y-axis. (in other words, the first (bottom) value will be 4:00 AM (which is what I want), ...
user avatar
0 votes
1 answer
42 views

How to exclude errored cell in SUM or Average formulas?

I am working with my timesheet here, and wonder if it is possible to exclude those errored cell from being counted (see I5 cell) either in I23 cell or even better to make I5 blank or 0 if G5 is empty? ...
user avatar
0 votes
1 answer
111 views

How to create a scatter plot from a table with a header column in Numbers

I'm struggling with 2D Line and 2D Scatter plots in Numbers (v11.2). Consider that I have a very simple table where the first column is a header column : Stuff (header column) Things 1 1 2 2 3 3 ...
user avatar
  • 865
0 votes
0 answers
45 views

AppleScript: Can't add text to Numbers cell

I'm trying to add text to a Numbers cell but I keep running in a -10006 error: Can't set <object or data> to <object or data>. Here's the relevant portion of my script. set rowNum to 1 ...
user avatar
  • 101
-4 votes
2 answers
243 views

How can I turn off the "Numbers" application?

"Numbers" is the Mac OS counterpart to Excel. When you extract data from the Web, you can often export it into the .csv format, which is just a primitive version of Excel limited to a ...
user avatar
  • 121
0 votes
0 answers
88 views

Specific Date Format with AppleScript in Numbers Cell

I am copying with AppleScript a short date string from a cell of date format and paste it to other cell of another table. I want the later cell should be formatted as "Month Year" format, i....
user avatar
3 votes
2 answers
4k views

Numbers can’t be installed on “macos” because macOS version 11 or later is required

I have used Apple Numbers in the past, have deleted it because of a tiny 128GB ssd. I'm still on macOS 10.15 Catalina, want to install it via the Appstore, and get this message: Numbers can’t be ...
user avatar
  • 1,064
0 votes
1 answer
38 views

How do you filter out rows from a table

In a table with tens of thousands of records, I need to filter out all records where the first column of each record has "B" as value. I've tried activating "all filters but B", ...
user avatar
  • 172
2 votes
0 answers
80 views

Run Numbers '09 (v 2.3) under Catalina or later

I vastly prefer running the older Numbers for Mac (Numbers '09). I've kept my iMac running Mojave for this reason. But I'd like to upgrade my OS. What (if any) is the best way of running Numbers '09 ...
user avatar
1 vote
0 answers
931 views

How would I export data from Python to spreadsheet (Apple Numbers Format)?

I'm currently trying to automate the export of data from a Python script to Apple's .numbers spreadsheet. Currently, I export from Pandas using .csv. My specific use-case is to update an existing ...
user avatar
0 votes
1 answer
124 views

Sort Numbers COLOURED ROWS

I know you can sort columns by their color, but how do you sort ROWS by their colors in Numbers? Any help would be gratefully appreciated.
user avatar
  • 1
0 votes
1 answer
132 views

I can't edit a shared Numbers spreadsheet

I can't edit a shared spreadsheet in Numbers and an alert pops up to say a new update available. So one would think I need to update Numbers, right? But no, I have the most current update, so after ...
user avatar
  • 1
-1 votes
1 answer
67 views

How do you copy formulas that reference other sheets from one Numbers spreadsheet to another?

What I’m actually trying to do is to copy the sheets from the included Retirement Savings spreadsheet into another spreadsheet. However, while I can copy and paste the sheets just fine, they paste as ...
user avatar
  • 475
1 vote
1 answer
37 views

How to exclude the numbers written in two cells in Apple's Numbers app?

Hopefully someone can help me as this has me stumped all afternoon! I have a spreadsheet and I have two columns that are added up to get the average. The formula i'm using is this: AVERAGE H2,I2 I ...
user avatar
  • 15
0 votes
1 answer
30 views

OSX Numbers Checking for either of two text values

Using MacOS Numbers to count the number of cells containing hello or world: . Y 1 hello 2 world 3 hello world 4 world world 5 world hello 6 world bye 7 hello flynt The result I'm expecting is ...
user avatar
  • 1
1 vote
0 answers
11 views

Numbers for iPad If checkbox false then clear value so when ticked again cell is blank for next manually input value

I have 2 tables on top of each other. Table 1 contains a checkbox in cell F80, when ticked its cell background colour changes to dark green. On top is Table 2-1 which has text and outlines in sheet ...
user avatar
1 vote
2 answers
37 views

How do make Cmd + S files save to the file I opened with numbers with its existing format/extension?

I usually open .XLSX files with Numbers for quick edit. However doing Cmd + S makes Numbers prompt to save the file with .numbers extension. How do I override this behavior?
user avatar
  • 259
0 votes
0 answers
16 views

Can LOOKUP be used to find category summaries?

Recently accustomed to LOOKUP (somewhat), game changer. Was hoping to know if there was a way to search for the summary as in this example? If i change the liquor, the ABV will change, changing the ...
user avatar
2 votes
1 answer
43 views

In Numbers can a chart follow a table's increasing range?

I'm growing a table and also have a chart associated with it but when I add columns I have to go back to the chart and "edit data references". When I was growing the chart from right to left,...
user avatar
1 vote
1 answer
49 views

Is there an AppleScript command to zoom a sheet in Numbers?

I think the answer to this question is "no", as I've not found any mention of it in the Numbers dictionary, but I thought I would ask here in case it's an undocumented feature. I have a ...
user avatar
1 vote
1 answer
133 views

Can a sheet be made active using AppleScript?

I'm wanting to activate a particular sheet in Numbers using AppleScript. I know that if a table is on the sheet then it can be activated by doing something like this: tell the table 1 of sheet 2 of ...
user avatar
2 votes
2 answers
2k views

JSON data into Numbers

I'm new to applescript, and found this language very hard to use. I try to write applescript that will fetch the token prices and symbols, and put them into Numbers. To do that we have to call the API ...
user avatar
  • 121
0 votes
1 answer
122 views

Activate Numbers app and populate chart every 30 minutes

I'm editing this again to show the latest revision. Thanks to everyone's help here and some digging of my own, I've been able to get this to run in the background by avoiding the use of "system ...
user avatar
0 votes
1 answer
52 views

Searching Sheets in Numbers to Total an Amount

Im building a cookbook for a restaurant that I work at in Numbers and need to total the amount of supplies I need for an ordering guide. The ordering guide is as follows: I want the green cell to be ...
user avatar

1
2 3 4 5
14