Stack Overflow
Stack Overflow

Questions tagged [apple-numbers]

A spreadsheet application developed by Apple Inc. part of the iWork productivity suite.

53 questions
1
vote
1 answer

Find index of first digit in string

How can I find the index of the first number in a string? For example, if I have a cell with "ABC099", the function should return 3. I found this for excel but ISNUMBER is not an apple-numbers…
Stephen
  • 23
  • 5
1
vote
1 answer

Set default or constant value for a column in macOS Numbers

I am looking for a way to add default or constant value to a column in macOS Numbers? When I want to create a new row based on previous row I should always copy and paste the values after adding which is a bit annoying.
Soheil Novinfard
  • 1,358
  • 1
  • 16
  • 43
1
vote
1 answer

Apple Numbers: Convert Date format M/D/YY or D/M/YY to YYYY-MM-DD

Note: I had this question, couldn't find an answer and can provide the answer myself. I hope this can be used by others too. Using Apple Numbers, how can I convert the date format of M/D/YY to YYYY-MM-DD by using a formula? M/D/YY…
AlexGrafe
  • 8,292
  • 1
  • 15
  • 12
1
vote
1 answer

Selecting only check marked rows in a different table - Mac Numbers

I have a table in Mac Numbers which has a column with checkbox. I am trying to copy only those rows in a second table which are check marked. I also want to extend this solution to multiple tables; I will have multiple tables having a column with…
Abhinav
  • 37,684
  • 43
  • 191
  • 309
1
vote
0 answers

Numbers help creating aggregates

I have a table with rows of multiple types. How do I create another table from it so that the rows in this table reflect the sum of all rows of each type from the previous table. For e.g. I have a Table1 with 5 rows of type A, 6 rows of Type B. I…
user220201
  • 4,514
  • 6
  • 49
  • 69
1
vote
0 answers

Need to extract data from a .Numbers file

I need to extract some images from about 1000 rows in a numbers file and I'm convinced there has to be a more efficient way to do it. Ultimately, I'll be inserting all of this data into a MySQL db and I was hoping to use a CSV file but phpMyAdmin,…
Optymystyc
  • 130
  • 1
  • 11
1
vote
0 answers

How do I check a new Numbers file into git using Xcode?

Apple's "Numbers" spreadsheet app just changed file formats, where the new one is bundle-based, essentially a single-icon representation as far as a user is concerned, but a folder of stuff under the hood. I have a spreadsheet where I keep track of…
Lightbow
  • 143
  • 1
  • 6
1
vote
2 answers

Count repeated values in a column

I have a column of year values by which I am sorting. I'd like to find the quantity per year (read: number of repeats of each year value). I'd like to chart said values. I'm not sure how to make this happen. I am using Apple's Numbers '08, but if…
grey
  • 1,150
  • 1
  • 19
  • 35
0
votes
0 answers

AppleScript: How to auto send emails with contacts in Apple Numbers Sheet, using Apple Mail

I have been trying this but something or the other is not working fine. The following is my script which I have put together after much searching around: -- Set the starting time set startTime to current date set startTime to startTime + (1 *…
user7460736
  • 11
  • 5
0
votes
1 answer

Applescript for Apple Numbers, Move data around from a single column

I am trying to use Applescript to help automate cleanup of a spreadysheet I have a spreadsheet with all the data in a single column, basically a monetary amound and a date. I am trying to separate them out of the single column into columns A and…
Will Cloxton
  • 3
  • 3
0
votes
0 answers

How to delete cell data upon data entry in Apple Numbers?

I'm trying to make a quick reference sheet for a TTRPG campaign, and I'm trying to create a section of the sheet that will account for leveling up, and by extension, skill points. Since I will not know how the players wish to split skill points, I…
bread_one2three
  • 3
  • 3
0
votes
1 answer

(apple numbers) Search query for adding values

Im making a sheet to have control over my investments. To do this I'm making one table overlooking my buying history, and one where all my investment holdings show. STOCK SHEET What I want to do is to search the history table and add up all stocks…
krimkromson
  • 1
  • 2
0
votes
1 answer

How can I create relative HYPERLINKs to local files in a cross platform way?

I want to be able to create a XLSX file which contains links to files in the same directory or in sub-directories and be able to open them on different platforms (macOS, Linux, Windows) and different spreadsheet programs (Excel, LibreOffice, Apple…
adius
  • 13,685
  • 7
  • 45
  • 46
0
votes
1 answer

Apple Numbers sum if is date is in Month

In Apple numbers I tried to sum cells if the date is in a specific month. So I have a column A with a date and column B has a price. Date Price 29-07-2021 12,50 16-06-2021 15,00 I use the function sum.if and the function month that…
Bert
  • 67
  • 5
0
votes
1 answer

Python CSV (DictWriter) overwriting data?

I've had a Python script running for the past 3 months. Simple scraper that grabs the date, points, and current time it collected that day and writes it into a CSV using DictWriter. Cause of bug Yesterday, I had to open the CSV (with Apple's default…
Rohan Shah
  • 479
  • 3
  • 14
1
2
3 4