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
1answer
27 views

(iWork) Numbers: Cut and Paste, macros

Is there a way to "cut" certain cells and paste them to another cells or sheet without losing formulas with references to other cells (such as MS Excel does with command+X). Numbers does not ...
1
vote
2answers
48 views

How to automate find and replace in numbers with a predefined list?

How can I automated find and replace in a Numbers file based on a predefined master list? For example, I want to find and replace all: "ABC" to "XYZ" "123" with "...
0
votes
0answers
10 views

I can no longer paste tab delimited text from Pages into Numbers mac

it seems as if the "import settings" is gone. I can no longer "separate values using:". So now when I copt text from Pages (which includes tabs for the purpose of filling different ...
0
votes
0answers
7 views

How to Specify a Dynamic Date Condition using SumIfs in Numbers?

How does one change the condition highlighted in the attached image to a dynamic date condition? ">=4/3/2021" into something like ">=A3"
0
votes
0answers
12 views

How to increase/bypass the limited amount of only three (3) rules of a custom data format in Numbers.app (10.3.9)

I want to create a custom data format that automatically changes numbers (1 to 5, which I can use for calculations and statistics) to symbols (++, +, ✓, ○, ✕). The definition of a rule in a custom ...
0
votes
0answers
17 views

Change date (but not time) in datetime column to date in date column

I have a table with, among others, two columns, one for a date (e.g. "22. March 2021"), the other for a time (e.g. "16:00"). Internally, the date column contains only dates, but ...
0
votes
0answers
17 views

Apple Numbers - Paste tab separated value list

How can I paste a list of floating point values into Numbers such that it is split automatically to several cells? The list looks like 1.2345\t2.345\t4.435634\t3.456 The delimiter can be replaced by ...
0
votes
1answer
43 views

Apple Numbers SUMIF with multiple conditions

I recently switched to Numbers from Mac Excel and a formula is not working. I am taking the sum of a range of cells where a SUMIF condition is met. The formula worked in Mac Excel but Apple Numbers ...
1
vote
1answer
61 views

running Numbers on Mojave

Several months ago I updated the OS of my MBP (early 2015) from Yosemite to Mojave 10.14.6. Numbers does not work any more. Tried to reinstall it from the App store but they say I need OS 10.15. In ...
0
votes
0answers
21 views

HTTP request in Apple Numbers formula

I'm trying to return the current Bitcoin price from an API endpoint of my choice in an Apple Numbers cell. How can i achieve this with a formula? Is there a way to evaluate JavaScript? In pseudocode ...
0
votes
0answers
11 views

Correct time zone when using “now” button in a shared document

I made a shared .numbers document with a column with data type “Date & Time”. On iOS, this results in a keyboard with a “now” button that inserts the current date and time. I want people I’ve ...
0
votes
0answers
13 views

Customizing a Chart in Apple Numbers by Combining Columns

I have a chart where I am tracking reading progress through the Bible. I have the books in a table with the following data as columns: Book name Book length (in time, as measured by an audiobook) A ...
2
votes
1answer
93 views

Numbers - multiple conditions in an if statement

I am trying to do this: IF(day(now()) > 28 and day(now()) < 1, A1 + B1, A2 + B2) However this gives a syntax error. Is it not possible to have more than one operation in a condition? I don't ...
0
votes
1answer
27 views

Conditional formatting when checkbox checked

I am trying to make conditional highlighting accross whole row when a checkbox is checked. I found a tutorial to make this happen, but it doesn't work for me. If you know a better way to do this, ...
0
votes
0answers
15 views

Apply XIRR only to filtered rows in Numbers

I have one table with the cashflow of different investments, like the example below. Now, in a seperate table, I want to show the internal rate of return for each investment. Numbers does have a XIRR ...
0
votes
0answers
13 views

Conditional formatting in numbers with fixed comparation cell

Given the following sheet in numbers: I would like to highlight the maximum value for each column in green, and the minimum value of each column in red. I thought this can be done with conditional ...
0
votes
1answer
60 views

Numbers: Possible to transpose Rows and Columns during Import of txt file?

I have a txt file which has 5,000 data points separated by commas. i.e. data123,data456,data17,data918,etc,etc If I open this txt file in Numbers, it creates each item as its own column, whereas I ...
1
vote
0answers
21 views

In Numbers, how can I find all references to a cells?

I got B3=B2÷B1 and when I click B3 the B2 and B1 get highlighted with the colours you see. I want B3 to be highlighted when I click on either B2 or B1. My search engine and StackOverflow did not ...
0
votes
0answers
8 views

How to include footer cells in formula when selecting column range?

I have a sheet in Numbers where I have couple of values in columns and have one footer row. I need to include the cell in column including the footer. For e.g. in the below screenshot, the XIRR ...
1
vote
1answer
28 views

How to sort column by numbers in Numbers?

I would like to sort a column in ascending or descending order by number of objects in Numbers. However, despite setting the 'data format' as 'number' it doesn't understand the right order. This is ...
0
votes
0answers
45 views

Numbers standard cell dark mode

In Numbers, is there any way to make all standard cells of all spreadsheets (including existing spreadsheets created by others) be displayed in dark mode (i.e. have a black background with white text)?...
0
votes
1answer
66 views

How do I Employ CJK's AppleScript “makeASDate” Handler Without Error?

I am attempting to employ the makeASDate handler shared by user CJK (which I lifted from his answer at Apple Script: Can’t get date of "2018-12-12 10:00 AM") in order to set up some calendar ...
0
votes
0answers
13 views

Add a column to iOS Numbers “form data” sheet, without adding a new form entry

I have a form in iOS Numbers. For each new row added through the form entry UI, I want to calculate some auxiliary data for that row, which is essential to the summarizing formulas that I'm going to ...
0
votes
2answers
78 views

Apple Numbers use Actual date instead of formatted date

I have a spreadsheet with a list of months as the columns with the value 1/1/2020, 2/1/2020, 3/1/2020, etc. The cell format has been set to January, February, March, etc. When I attempt to use date ...
1
vote
1answer
22 views

Number : calculate percentage using two cells

I can't believe I ask that but my brain seems offline this morning I have two column (D1 (Day units) / E1 (Night units) I want to create a new column with the percentage of use between day/night (with ...
0
votes
0answers
34 views

Using regex.extract with capture-groups argument fails when capture-group is null

Using regex.extract in MacOS 11.0 Big Sur numbers app version 10.3.5 (7029.5.5) on MacBook Air M1. Using a regular expression which contains one or more capture-groups that are not filled by a match, ...
0
votes
0answers
40 views

Duplicate rows in Numbers with Applescript

I have a template with 20 rows of data. I am trying to figure out how to select these rows and then duplicate them a varying amount of times depending on user input. When I do this manually, I have to ...
0
votes
1answer
21 views

Why one can Control+Option+U to edit a cell on Numbers?

It has been noted there are two ways to edit a cell on Numbers, Option+Enter seems to do the job. But still there is Ctrl+Option+U, why?
0
votes
1answer
20 views

In Numbers, how to navigate on text inside a cell after pressing Control+Option+U?

In Numbers we can use the ControlOptionU shortcut to edit text in a cell. Doing so the cursor goes to the end of the cell (the right side) here. What if I want to edit in the middle of the text? One ...
7
votes
1answer
649 views

Almost all Functions in Numbers on MacOS Give Me Syntax Errors

Almost all functions I try to use in Numbers give me a syntax error with no explanation what is wrong (red triangle with exclamation mark, only says "The formula contains a syntax error." ...
2
votes
5answers
4k views

Need Mac Numbers & Pages for Mojave

I have a 2010 MacPro running Mojave. I've been trying to buy, copy, or steal copies of Pages and Numbers for hours just so I can work on a client's Pages file. Why is this so hard?
0
votes
0answers
38 views

I'm trying to split text from numbers and sum up total amount from the last numbers

I build an shortcut that helps me following my medicine consumption and I want to get info once/two a day regarding the total amount I consumes at the same day/In the last week and so on. This is how ...
0
votes
1answer
190 views

How to download and install updates to these Apple apps in this macOS without an Apple ID? Can I download the installer? If so, from where exactly?

I need to update Numbers, Pages and Keynote on macOS 10.15.7 but I do not have an Apple ID. Is it possible to update macOS without Apple ID? has an answer which is insufficient for me and is closed so ...
0
votes
1answer
13 views

Range of values for a cell in Numbers?

Is it possible to have a range of values for a cell in Numbers? E.g. for financial calculations involving income and costs, is it possible to have a "vague" value like $ 1,000 - 3,000, and ...
0
votes
0answers
11 views

Apple - numbers - how do i automatically retrieve cell data from different sheets?

I am creating a performance calendar that includes an overview sheet named "MONTHLY" that has columns named "WK 1", "WK 2" and so on for each week of the year. In each of ...
2
votes
2answers
84 views

How to determine if all items in a list are the same

I'm currently in the works of an AppleScript calculator that extrapolates arithmetic linear sequences (sounds fancy but it really isn't). One of the processes it must go through is finding the common ...
0
votes
1answer
37 views

How can I combine text in multiple rows into one text block in numbers?

I am attempting to automate a set of instructions that have variables. I can combine the text across the rows. But I need to then combine each of the final rows together for one simple text block that ...
0
votes
1answer
23 views

How to add a calendar month to a date?

In Numbers, if I have a column for dates, and I want each cell to be one day later than the cell above, I can enter a date in the first cell and then set the next cell to be "cell above plus one&...
0
votes
1answer
20 views

Numbers MAX Formula unexpected result

Goal: Display MAX (greatest) current result from column which keeps growing Current issue: I can have all current entries regarded, however a newer, higher value gets ignored. Attempts to set up : =(...
0
votes
1answer
173 views

How to import text to columns and import numbers to text in macOS Numbers?

Windows Excel allows me to paste a body of text and in the bottom right corner of the pasted content, a menu prompt will pop up that can initiate the "Text Import Wizard" to import delimited ...
0
votes
1answer
60 views

Numbers : sum if tick-box on next column is true

I have 3 column in a numbers sheet (A) Text | (B) Currency | (C) Tickbox At the end of (B) Currency, I have a very basic formula SUM(B) What I'm trying to do is to have the same SUM(B) at the footer ...
0
votes
0answers
8 views

Is it possible to have a second table of Numbers data sized dynamically based on the first?

I'm making a Numbers inventory sheet of cable and hardware plug tips. The first table is just an unformatted log of devices I'm adding, with the columns: Device Name | Plug Type iPhone | ...
1
vote
1answer
796 views

Unable to collaborate on a Numbers spreadsheet

I have a Numbers spreadsheet that I have previously setup to use Collaboration with my wife. A few weeks ago, as I was editing the spreadsheet on my Mac, Numbers told me that it couldn't connect to ...
0
votes
1answer
27 views

How to configure the category gridlines in Numbers?

Below are two charts with and without gridlines. Obviously the one with gridlines isn't very useful. I would like to just have a gridline every 10 years or something like that. How do I do that?
1
vote
1answer
52 views

Generate TSV/CSV with multi-line cells that open in Numbers

I want to programmatically generate tsv files with multi-line cells that stay preserved when opened in Numbers app. What newline character to use to enable multi-line cells?
0
votes
0answers
16 views

How to join a range in numbers?

I want to join the cell values of a certain range to a list with some separator. Example Given this table | A | 1| 7 | 2| a | 3| 4 | .| . | .| . | .| . | If the delimiter I choose is || the resul ...
1
vote
1answer
34 views

Search Numbers spreadsheet for \n

If I search for "\n" in a Numbers spreadsheet, it only shows me any cells that have line breaks in them, it does not show me cells that have "\n" written in them. Is there any way ...
0
votes
0answers
13 views

Is there a way to get a current (15 minute delayed) stock quote into Numbers?

I know about STOCK and STOCKH but both of those are only good for the close of the previous day. Is there a way to get the current stock price, which would probably imply a 15 minute delayed price, in ...
0
votes
1answer
20 views

Cell formula based on finding an index on another sheet

I have a numbers file with a first sheet like this: Then a second sheet that looks like this: For each row in sheet 1 I need to find if there is a matching SKU on sheet 2 (sheet 1, col N with sheet ...
0
votes
1answer
20 views

Import text from webpage directly into Numbers cells

In a numbers file I am using, whenever I open it I need to manually import a specific value from a webpage. Specifically, from this webpage I want to import the USD to EUR ratio. Any other similar ...

1
2 3 4 5
13