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) like these errors 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.
I've performed non-trivial web searches and searched all the features I could find within Google Sheets, and I see nothing like this feature. The only other option I see is writing a significant, embedded script or other automation, which is what we're looking to specifically avoid.