For complex Google Sheets with many tabs (my teams effectively employ Google Sheets as a sort of database in these scenarios), is there a relatively-easy way to search for any and all formula errors (across all tabs) without having to create a script?
I’m thinking something like a
Find and replace option that offers a
Find formula errors checkbox.
The purpose: when adjusting formulas, named ranges, and the like: it’s quite cumbersome for a spreadsheet designer/maintainer to manually look through all formulas in all tabs to find if anything is broken. We’d rather employ some automated-find-any-errors mechanism to avoid such efforts.