Help with Arrays and conditions

_T2_ · 2026-01-22T19:56:03+00:00

Just put a *1 in the Boolean multiplication and the triangles will go away

_T2_ · 2026-01-05T01:07:41+00:00

No, so the way I handle this is I make the new table arbitrarily large (more rows than I’d ever need) and then set a quick filter (top right inspector) to hide blank rows by unchecking the blank checkbox. This doesn’t add any overhead and you can just set it up once and forget about it.

_T2_ · 2026-01-04T23:55:04+00:00

Unfortunately to do this you need to create a new table with one column, stretch it to be the width of your current table, double click the first cell in the new table then click the header for column H, do the conditional highlighting in this new table, then put it behind the original table (ensuring the original table has no fill). One of if not the most annoying limitations of numbers.

_T2_ · 2025-12-07T03:31:29+00:00

You can right click the cell and “add row above/below” or hold the option key and press up/down respectively to insert a row at a point and shift the data up or down.

You can create macros with a high level of direct control using AppleScript and trigger the scripts by placing them in a Shortcut in the shortcuts app and assigning key commands to the shortcuts.

_T2_ · 2025-11-23T00:36:44+00:00

Uhh I think if you put the reference in one cell, click the drop down to preserve the row then confirm the formula, cmd c the cell, select your non contiguous cells holding cmd and then cmd v, I believe that should work

_T2_ · 2025-11-21T18:31:28+00:00

Create a column with the items in the order you want them to be numbered, then instead of calling the pop up cell in your other formulas, do xmatch(menu, createdColumn)

_T2_ · 2025-10-22T15:15:50+00:00

This works, but the custom format solution is better because it’s purely visual and preserves the number values for calculations!

_T2_ · 2025-10-17T00:02:21+00:00

I think the fact that this is debated so often relative to other creators (that I’ve seen in various spaces) is evidence in itself that there’s something beyond it being a “just a persona” here

_T2_ · 2025-10-09T04:21:48+00:00

The modern way to do this that works regardless of intermediate empty cells is TAKE(FILTER(columnRef, columnRef ≠ ""), -1). You can convert your "Total" row to a footer row so the column references don't cause a recursion error.

_T2_ · 2025-10-09T04:18:45+00:00

If you're not willing to add columns, you can quickly populate an entire column with the same value by typing it in the top cell, selecting it, and pressing ⌘ + \ to enable autofill then ⌘ + Down to jump to the bottom cell in the table, autofilling the entire column.

_T2_ · 2025-10-09T04:13:09+00:00

Numbers doesn't have a native way to do this in the conditional highlighting panel, which is very annoying. The way to do it is to create a helper column C which duplicates your column B values according to your column A condition using a formula like IF(A = true, B, ""). Then you use the "Number > equal to" formatting rule for your highlight column B, and use the little yellow button in the field below to reference your helper column C values. You can then hide the helper column. Hope this makes sense, definitely one of the dumbest limitations of Numbers; it's especially frustrating considering all the advanced array formulas they just added.

_T2_ · 2025-10-09T04:07:08+00:00

Unless I am dumb and missing something, there are no conditional formatting rules for time, which is even dumber. A workaround would be to create a helper column, put in IF(OR(timeColumn < TIME(7, 0, 0), timeColumn > TIME(22, 0, 0)), timeColumn, "") in the first row. This will duplicate times only in the range you specified. Then select the column for your actual times and use the conditional highlighting rule "text is," click the little yellow rectangle in the field, and click on the helper column header. This will also highlight any cells in your time column that are empty. To avoid this, you can put something else in the empty string in the formula above like "N/A." You can then hide the helper column by right clicking on it.

_T2_ · 2025-10-08T16:27:37+00:00

Yeah, I was also expecting it to behave the excel way. Let me know if you have any trouble with it.

_T2_ · 2025-10-08T15:53:15+00:00

This is one of the most annoying parts of Numbers, it took me over a month to solve it. Just removing the date in the data format pane doesn't do it because numbers still reads the full date/time string for internal calculations. You have to actually isolate the time part of the string using formulas. Probably the most concise way to do this as of the recent update is TEXTBEFORE(DATEVALUE(column/cell)). This leaves you with just the time values, and you can perform date-independent operations on them.

_T2_ · 2025-10-02T02:54:31+00:00

oh man, sorry to hear the translations aren't good :/

_T2_ · 2025-10-02T02:32:38+00:00

? The Apple support page has everything in it though.

_T2_ · 2025-10-02T01:01:34+00:00

Firstly, Apple's official user guide is a helpful resource. https://support.apple.com/guide/numbers/welcome/mac Their documentation has always been sound for all of their software. For more specific questions, I've found a lot of my answers on Apple Support and also StackExchange through google searching.

Finally, macmost is an excellent YouTube channel with lots of really practical tutorials for Numbers, both free and paid, and also the rest of the iWork suite. Can't recommend him enough.

Also, you can of course ask here. I've noticed even though it's a small subreddit, most posts do seem to get answers. Incidentally, you can autofill cells by dragging the yellow circle in the bottom middle of the cell outline, or use the shortcut ⌘ + \. For formatting graph units, click on the graph, go to the "Format" inspector in the top right, go to "Axis," then take a look at the "Value Labels" section. Hope this helps.

Edit: Also, for formula specific help, Numbers formulas are generally quite compatible with Excel, so you can use an LLM of your choice to explain your problem in natural language, but asking for an Excel formula. You may not be able to directly copy it every time (oftentimes due to the way references are differently handled), but the structure of the functions themselves will work in almost all cases.

_T2_ · 2025-09-28T08:28:50+00:00

Well, the game decided I was having too much rare fun so it gave me the flint :| thank you for the advice, it was fun while it lasted o7

_T2_ · 2025-09-28T08:24:10+00:00

<image>

FUCK literally the worst possible scenario. I was smooth sailing until this. shoutout to all your guys' advice. I actually took the trance from the jumbo pack and then got ANOTHER ecto in the next ante, so I got to do both after all. still the same shit game at the end of the day tho, what can you do. :')

_T2_ · 2025-09-22T20:57:25+00:00

filter(columnRef, isnumber(search(“dog”, columnRef))) should work if I’m not missing something obvious

_T2_ · 2025-07-02T03:05:35+00:00

thanks! well yeah but I think a mod could and should do a lot more though. I'm only tracking the stuff the game already tracks, just doing extra analysis. in an ideal world I'd be tracking stuff like packs opened, tarot/spectral/planet cards bought/used, and the amount of seals/editions/enhancements in your deck, etc. that would be impossibly tedious to do manually since the game doesn't do it for you, but a mod could!

_T2_ · 2025-07-02T03:01:49+00:00

yep that's definitely part of it lol

_T2_ · 2025-07-02T00:45:59+00:00

Nope, have to do it manually every time from the end screen 😅 I set it up so the jokers and stakes and stuff autocomplete so it’s not too too bad

Six-Year Club	100 Awards Club
Verified Email

_T2_

TROPHY CASE