I am sort of confused about the behavior when sorting by a columns content. I have this formula in A1:

={"Page";arrayformula(iferror(filter(Events!A16:A,Events!C16:C="Feedback R"),""))}

I get the list fine, but if I go and sort the column Z - A, it works but only for a second, then the formula seems to regenerate the list in A - Z order again.

Should I write the formula in some other fashion or am I misunderstanding something about spreadsheets in general?

1 Answer 1


You are missing that formulas are recalculated automatically. Formulas that use built-in functions are recalculated when the spreadsheet is opened and every time that a change is made.

Instead of using the sort functions of the UI, you could include in your formula SORT (the built-in function), rebuild your formula and use QUERY (another built-in function) or to do a copy & paste only values to another place and use the sort function of the UI in that place.

Another alternative is to use Spreadsheet Freezer (it's a Google Sheets add-on that I published as unlisted in 2019 and very recently I made public; Google Sheets add-ons are free)


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.