Hi all, looking for suggestions based on others' experiences. We have a series of dashboards and their respective back end sheets that occasionally throw formula errors for various reasons. I'm hoping I can leach some ideas from the Community on creating a master report/notification that informs us when any error occurs.
The easiest thing I can think of so far is to add a row to each of the back end sheets, with maybe a checkbox column, that checks if there's anything in the whole sheet that includes "#" (we don't use this character for any of our metrics on dashboards so the chances of it pulling something that's NOT an error is slim). We could then create a report that pulls any sheet name where that box is checked so we can quickly diagnose and correct the issue.
We have formulas on any number of columns across ~50 sheets so far, so creating an actual Smartsheet report isn't an option.
Has anybody implemented an easier solution? This wouldn't really be difficult going forward when making new back end sheets, but wondering if we can find a better solution before I add this row to the ~50 existing sheets.
Thanks in advance!