Deleting Google Sheets Records

[Darren_Murphy]

@Mark_Turrell

And every once in a while there is a g-formula that does not work in a standard way with =arrayformula

Here is a scripting solution for functions that don’t work with ARRAYFORMULA…

Scripts, scripts, scripts!

Here is another one that I use all the time as an alternative to ARRAYFORMULA. The neat thing about this is that it works with any formulas, whereas ARRAYFORMULA has some limitations. Again, I didn’t write this one myself, and I can’t recall where I got it from (probably Stackoverflow), so I can’t take any credit for it. But I’ve been using it for 3 or 4 years and it’s never failed me. What it does and how it works is described in the comments.

Summary

/** * Copy Formulas Down * This script…