Forum Discussion

Bobby_Notlok's avatar
Bobby_Notlok
Copper Contributor
Jul 31, 2023

Sorting a table works in Excel but displays error on iPhone

Hello, I have a spreadsheet with a sort formula to place in descending order about 9 rows and two columns. It works perfectly in my Mac but displays a #¿NAME? error when I try to open it in my iPho...
Excel on mobile
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Aug 01, 2023
It seems you are opening the file with Goggle Sheets and SORTBY() is not a valid function in Google Sheets.
  • Bobby_Notlok's avatar
    Bobby_Notlok
    Copper Contributor
    Aug 01, 2023

    Detlef_Lewin you are right, I was.

    I changed the formula to SORT() and it's working now. 

    Thank you.

Resources