There are several questions about a Google Sheets equivalent for the Excel function TOROW().
Those questions and their answers became obsolete on 1 February 2023, when the function TOROW() was added to Google Sheets, as can be read in this Google announcement. The documentation for the new function can be found in the Google Sheets help. It really does now exist, or is supposed to.
I immediately put this function to use and added it to a spreadsheet in progress on 15 March. I opened that spreadsheet this morning to see a mass of #NAME? errors, and mousing over the error reports "unknown function: ‘TOROW’". Just to check, I created a fresh spreadsheet with just a single call to the function, like this:
=torow({1;2;3})
and this is the result:
:
I’m including this as an image because that is the only way to display the popup, which is what this question is about, and if your Google Sheets works as documented, you should not be able to re-create the error.
Is this a spectacular regression, or is there something I’ve missed, like a switch to emulate a previous version of Google Sheets?
>Solution :
As per info from docs community some of these new functions are paused at this very moment and no clarity on ETA