MicrosoftIs anyone seeing a lot of formulas being wrapped with SINGLE() after getting the new functions?
I have a number of spreadsheets that return a single row table from Power Query, and then I refer to those tables in other formulas. So =TableName[FieldName] would give me the count of rows in a query, or the total of a value, etc. Usually used for error checking. One of my files this morning had 7 SINGLE() functions in it. some simple as above, some deeply nested in those stupidly long uneditable formulas I am prone to do over time.
Now those are all showing up as =SINGLE(TableName[FieldName])
Creating a new single row table in a new file, typing =Table2[data field] does not cause it to wrap in SINGLE(), however.... if I create the formula in Excel Online or an older version of Excel, =Table1[Test data] becomes =SINGLE(Table1[Test data]) when I open it in the new version.
EDIT: Is this the right place to discuss issues or questions about these new functions?
