Questions tagged [numbers]

A spreadsheet application developed by Apple as part of its iWork suite availble for iOS, macOS and cross-platform via iCloud. It is the Apple alternative to Microsoft Office Excel.

Filter by
Sorted by
Tagged with
0
votes
2answers
32 views

Pages and Numbers have generic app icon in Dock

I have a MacBook Pro 13" Unibody Early 2011 running macOS 10.13.6 (the latest it will support). I wanted to replace the HDD with a 256GB SSD so I did a fresh install to the SSD in an enclosure then ...
1
vote
1answer
25 views

Numbers - problems with a formula for “text to columns” behavior

I have a column with three comma separated RGB values that I want separated into three columns by formula, meaning I want a sheet that lets me paste "0, 0, 0" or "0,0,0", or "255, 255, 255" etc. and ...
0
votes
2answers
54 views

Why can I not have the date and time in one cell

I want to start at a date and at 12:00:00 am and I want each cell to increase by 1 hour. I put =a2+time(1,0,0) but I keep getting "The formula’s arguments can only include one date value." What am I ...
0
votes
1answer
33 views

Regarding AppleScript, is it possible to change “page layout” export option when exporting Numbers documents to PDF?

A little while ago I cobbled together a short AppleScript for exporting multiple Pages documents to PDF at one time, and now I want to do the same with Numbers. The basic principle is the same and the ...
0
votes
1answer
67 views

AppleScript tell Numbers make Pop-Up Menu from Contacts Group names, wait for input, then Email ScreenCapture

This is a bit long-winded, but here goes… Using AppleScript (vanilla, please), I want to automate the Numbers spreadsheet I made for my wife’s music lessons Accounts (which she uses four times a ...
1
vote
1answer
29 views

How to remove all cell formatting

How can all formatting be removed from a sheet in Numbers so each cell only contains the text, with links no longer clickable?
0
votes
0answers
17 views

How can I convert US-format date and time into a date value so I can use the local date format?

I am in Australia and use the default date formats here (dd/mm/yyyy). Unfortunately, BandCamp exports sales data using a US date format: "m/d/yy h:mmpm". For the most part, Numbers treats this as text ...
0
votes
0answers
29 views

How can I print comments in Numbers?

I have a Numbers document containing several comments. I'd like to include these comments when printing the document — or creating a PDF — but I cannot locate an option to do this. I've searched ...
1
vote
1answer
44 views

How can I see the list of recent opened files in Numbers?

How can I see the list of recent opened files in Numbers? Is this supported at all?
1
vote
1answer
110 views

Batch exporting metadata from Finder

I have a folder containing over 2,000 web pages I've downloaded. Most of the file extensions are .html, though some are .pdf or .webarchive. My OS is Mojave. When I highlight an icon in Finder, it ...
1
vote
1answer
60 views

Sum of VLookups in Numbers?

I may just be missing the right terminology, spreadsheets have never really been my thing. But I'm struggling to combine SUM() and VLOOKUP() for my needs. (Assuming these are even the functions I ...
0
votes
0answers
21 views

Change line color of line chart in Numbers dynamically depending on value

I have created a line chart in Numbers: I would like the line color to change when the values lie below a certain value (e.g. 0): The values are calculated dynamically and change continuously when ...
0
votes
1answer
33 views

Draw a Pie and Bar Chart in Numbers

Hello I am trying to learn numbers. I have this table | ------- | ----------- | | Person | Status | | ------- | ----------- | | John | Not Started | | ------- | ----------- | | Gary | ...
2
votes
2answers
2k views

Old version (macOS Sierra) for Pages, Keynote and Numbers, iWork

I uninstalled my iWork tools - Keynote, Numbers and Pages - from my MacBook Air. Unfortunately, I don't want to upgrade my MBA to Mojave/Catalina in order to install. I looking for the working iWork ...
1
vote
1answer
19 views

Numbers.app force me to download Chinese fonts but the download always fails

Whenever I open the Numbers app the pop up always shows up, requiring me to download Chinese fonts. The dialog reads "Numbers.app needs to download the font. The size is 50MB.". However, when I ...
1
vote
1answer
59 views

iMessage checker

I'm trying to do a number checker in imessage. We all know that there is no such api, so I'm trying to use the tools at hand. The main took with past issues on this site on this topic. I made a ...
0
votes
1answer
37 views

Automatic export to .csv when saving .numbers

For now my workflow is: opening myfile.csv in numbers applying changes to myfile.numbers saving myfile.numbers export myfile.numbers to myfile.csv (overwrite old) Rinse - repeat when new changes ...
2
votes
1answer
22 views

Can I use a formula as a Table Name?

I would like to have a table name automatically generate when a root value is updated. For example, in my budget spreadsheet, I have Groceries 11/07 -> 11/06. In a cell, if I have a cell starting ...
1
vote
1answer
55 views

iCloud is not syncing files within Pages and Numbers folders

Ever since I upgraded to Catalina, I've had a problem where the files within the Pages and Numbers folders in iCLoud don't sync to my Mac, except for files I've created since the upgrade. However, if ...
2
votes
1answer
53 views

How to prevent displaying the total sum of A + B if columns A + B are empty

I have inserted a running total formula in my numbers sheet. It sums the total of Column H, which works fine. However when cells in columns H are empty it will display the last sum, which I do not ...
3
votes
1answer
21 views

Can I reference a hundreds value of a number from a cell in Apple Numbers?

For example, A1 has 12,345.00 I want A2 to output 345.00. Is this possible?
1
vote
1answer
31 views

Numbers uninstall reinstall

Lately Numbers has been quitting unexpectedly on my MacBook Air and all the pre-installed templates are gone. Also it quits when working on formulas. I'm thinking I could store documents in the cloud ...
2
votes
1answer
46 views

AppleScript Numbers Retreiving Cell Value

I have a script which loads a Numbers document in order to retrieve a specific cell value to use in creating a reminder. My code is below. I believe I'm using correct syntax to load the value into a ...
1
vote
1answer
122 views

AppleScript Opening iCloud Documents

I am trying to write an AppleScript to open a Numbers document, which is stored in the Numbers folder on my iCloud drive, so that I can access a cell value and create a reminder with it (or otherwise ...
0
votes
0answers
10 views

Matching multiple text strings with sumifs

I have a formula where I'm using sumifs to match several conditions in each row on a table. For the sake of simplicity, I'm reducing this example down to just the one condition I'm having a hard time ...
1
vote
1answer
36 views

Get the next date from column of dates

I have a table in Numbers with a column which contains dates. From that column, I'm trying to get the next date from today from that list and display it in a cell. Assuming today is October 12, 2019, ...
2
votes
0answers
35 views

Select all next non-empty cells in Numbers

Is there a way to select all next non-empty cells? as in pressing Shift+Ctrl+Arrow Key in Excel app For example, I'm now at A1 and A5 is empty. ▼ By what means I can select A1 to A4 by one key ...
1
vote
1answer
64 views

How to format a cell with data YYYYMMDD in Numbers to be a date type?

I created a custom format to try and format a date column to be used within categories. However, Numbers tend to keep reverting my custom format to "Automatic" and I'm unable to group the data as part ...
2
votes
1answer
19 views

How can I autofill a formula in Numbers, but keep some referenced values the same?

So I have a chart in Numbers (iOS version, but I can use the macOS version, if needed,) which has formula that references some values from the chart, as well as some values from a different chart. I ...
0
votes
3answers
87 views

Equivalent of =SUM(ABOVE) in numbers?

I have a table like this, I need to sum all fields above (exclude the header), the following formula works: =SUM(C1:C5) When I add more rows I must rewrite the formula, then I tried something like ...
2
votes
1answer
56 views

In numbers or pages for ios, Is it possible to force a trend line to start at (0,0)?

I was wondering, if, in whatever the newest version of ios, numbers, and/or pages, it is possible to force a trendline through a point on a 2D scatter graph (e.g. the origin (0,0)). I was hoping to ...
4
votes
2answers
679 views

Can I create something like a macro in Numbers?

I have this long formula that is used in a lot of columns: =SE(N17<60; DEF.NÚM.DEC(SOMA(60; −N17); 1); "✔︎ Aprovado") So, when I need to change something in this formula, I need to edit each one ...
2
votes
1answer
102 views

Applescripting Numbers to save, close and quit in an App instead of the Script Editor

After using Applescript to add a new row with data to a Numbers document, I'm trying to save and close the document and then quit Numbers. Using the script below to save, close and quit Numbers works ...
0
votes
0answers
156 views

How to disable updates notification on iPhone XR (iOS 12.4), such as for an update of Numbers?

I'm using iOS 12.4 on an iPhone XR. Toggling to "off" at Settings | iTunes & App Stores | Automatic Downloads | Updates does not prevent me from getting notifications that updates are available ...
0
votes
1answer
153 views

Copy and paste issue from Excel to Keynote table

I'm having a big issue when copying from multiple Excel cells/rows and then pasting into a Keynote/Numbers table. When I select multiple cells in Excel with named content such as 'David goes to the ...
3
votes
1answer
99 views

Numbers: menu or list to jump to a specific sheet?

Is there a way to access a menu or list of all the sheets in a Numbers document, so I can quickly jump to one specific sheet without having to scroll or page one-by-one with the previous/next keyboard ...
1
vote
1answer
235 views

Help with AppleScript to automate Numbers Cell Formatting

I do several mundane repetitive tasks using Numbers App on a Mac, and wish I could just automate the same with the help of AppleScript. I got Numbers Spreadsheet with several tables, on the selected ...
0
votes
1answer
27 views

How do I establish a secondary axis in Numbers on an iPad Pro?

I see various older questions and replies about secondary axes and presumably can make them on my MacBook Pro. But I’m often working outside on my iPad these days and its lack of anything like ...
2
votes
1answer
21 views

Numbers - continuous line connecting gapped data?

This question over on SuperUser is exactly the same as mine, in the sense that I have a CSV that contains gaps in each column, but I want to plot it as a continuous line. However, I'm using Numbers, ...
1
vote
1answer
63 views

How do I combine two text values from different cells to equal another cell?

Let’s say I always know my row will be 14. I only know the column by another value above it. For example, $Q$7 = A I want to be able to take that value A and add it so that my formula is now $A$14. ...
0
votes
0answers
10 views

How do I choose the minimum value from a lookup table?

I have a Numbers spreadsheet that I use to track my investments. One table includes each stock purchase (ticker, entry basis, entry date, number of shares, computed cost/share. I want to select the ...
0
votes
0answers
27 views

Conditional stdev function in Numbers?

If I have a set A of numbers in Numbers (hah), I can use averageifs to calculate the average of the subset of A which satisfies certain conditions. For example: Say I have the following table: If I ...
2
votes
1answer
295 views

How to interact with a Numbers sheet via AppleScript?

This question is related to: SUMIFS with comparisons to relative cells where I'm trying to figure out a way to do what I want using AppleScript. I've been searching the Web to find a way to set ...
2
votes
0answers
40 views

SUMIFS with comparisons to relative cells

(This is somewhat similar to How do I reference a cell from within a "...IF"-type function condition string? and SUMIF statement with two different conditions (Text based and checkbox)) I ...
0
votes
0answers
52 views

Unique values for x-axis in a number chart

I have a numbers table with a bunch of values in a column, and a count of the respective value in another column. If I am plotting this in a chart, how can I make sure that the values in the one of ...
0
votes
1answer
12 views

Generate a new table entry in one sheet from another

I have a numbers file with 2 sheets: sheet1 and sheet2. On sheet1 is where I am entering some data in some cells. On sheet2 there is a transactions table with different entries. Is it possible to ...
3
votes
1answer
136 views

In Numbers, how can I get a cell value from another sheet with a formula?

My need is to compare content cells from two different sheets in the same file and get the cell value from another column of the first one. This is the tested formula to find the right position: ...
4
votes
0answers
32 views

Transpose a colum into a line inside the same table using a keyboard and trackpad combination

Given the data on this table I type the formula "=B2" in cell "D2" and get Now, I want to select cell "D2" and somehow get the formulas "=B3" in "E2", "=B4" in "F2", and so on, thus resulting in ...
0
votes
0answers
23 views

Is there a way to get more than 5 frozen footer rows in Numbers?

There seems to be an arbitrary limit of 5 frozen footer rows. I'd like to have 10 or 20, because I like to do a lot of analysis on the figures, have them in the same table, and follow the columns as I ...
1
vote
1answer
43 views

How to set Inspector in Numbers for macOS hidden by default?

Whenever I open a spreadsheet in Numbers for macOS, the Inspector's Format tab opens up. I'd prefer to have it hidden by default. Is there any way to change this behaviour?

1 2 3 4 5 11