Forum Discussion
Solved
Formulas in excel for items uploaded to Google
We have been using the sheet in the link on our google drive but we are having ongoing issues with the formula erroring. The sheet is not working again now but did work for several years. Often I c...
work in excel on my desktop but once I drag them to our Google Drive
'cause GS is not Excel:
EY
A3=IFNA(ARRAYFORMULA(FILTER('All Stu - Alpha'!C3:I,REGEXMATCH('All Stu - Alpha'!E3:E, "EY1|EY2|EY3|EY4"))))
Bye
Your formulas are failing because Excel and Google Sheets handle certain functions differently, and when files move between platforms, formulas can silently break or return unexpected results. The most common culprits are functions like FILTER, SORT, UNIQUE, and Google‑specific ones (IMPORTRANGE, QUERY, ARRAYFORMULA) that don’t have direct Excel equivalents.