Anyone else having trouble with array formulas in sheets? I have a sheet with more array formula then one should probably have, and it's not updating on its own. I'm having to make a change to a range in the formula to get it to update. Wonder if it's the amount of calculation going on or something new.
Generally speaking, replacing numerous spreadsheet formulas with Apps Script functions that are executed on demand (custom menu option) or if necessary through onEdit event is more reliable. This seems especially true with same-time collaborators.
Add a comment...