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.
Best Answer
Google Sheets doesn't include that as a built-in feature. Please send a feature request direclty to Google through the Google Sheets Help menu
It's worthy to mention that FIND AND REPLACE can highlight / navigate through the cells diplaying an error, i.e.
#N/A
You could even use regular expressions to search for multiple errors.