What does the blue triangle after updating to Numbers 14.4 mean?

Numbers recently introduced compatibility with Excel's "dynamic array functions" that "spill" values into cells.

Old formulas automatically performed what is called an "implicit intersection" meaning if you refer to, say, an entire column the formula would automatically interpret that to mean the value in the column on the same row as the formula.

With dynamic array functions the @ "implicit intersection operator" tells Numbers to keep that old behavior.

Numbers inserted the @ automatically for you and added a blue triangle to alert you that things have changed. You can make the blue triangles go away by clicking one, and navigating through the pop-ups until you see the option to remove all triangles.

SG

I am not 100 per cent sure. Since it's increasing compatibility with Excel, a search the equivalent in Excel can help.

So far I'm just carrying on as usual in Numbers and trying to familiarize myself with the new functions. There are a lot of them! Listed below are the ones I could find. There may be others.

SG

New Numbers functions April 2025

Logical & Info:

BYROW()

BYCOL()

ISOMITTED()

LAMBDA()

LAMBDA.APPLY()

LET()

MAKEARRAY()

MAP()

REDUCE()

SCAN()

Numeric:

RANDARRAY()

MDETERM()

MINVERSE()

MMULT()

MUNIT()

SEQUENCE()

Reference:

AREAS()

CHOOSECOLS()

CHOOSEROWS()

DROP()

EXPAND()

FILTER()

HSTACK()

SORT()

SORTBY()

TAKE()

TOCOL()

TOROW()

UNIQUE()

VSTACK()

WRAPCOLS()

WRAPROWS()

Text:

ARRAYTOTEXT()

TEXTSPLIT()

DATE and Time

ISOWEEKNUM()

New operators:

# spilled range operator

Used to reference the entire spilled range of a formula by placing # after a reference to a spilling origin cell.

@ implicit intersection operator

Adds compatibility with Excel’s dynamic array formula system.

Thanks for this SGIII. I was getting very frustrated with these blue triangles and in some of the spreadsheets I have gone cell by cell deleting the @, because I didn't put it there and I could find no explanation of what the @ meant 😰