One broken cell can turn a whole column into #REF! or #DIV/0!. Formula Doctor scans the tab, lists every cell with an error, and marks the few cells where the problem starts. Fix those and the rest usually clear on their own.
It explains each error type in plain words and can wrap the starting cells in IFERROR so a report shows a blank or a zero instead of an error. IFERROR hides the error without fixing its cause, and a total can then look right while being wrong, so fix the starting cells first when the numbers matter.
Free and Pro
| Free | Pro | |
|---|---|---|
| Scan the tab you are on | Yes | Yes |
| Scan every tab at once | No | Yes |
| Show which cell started each error | Yes | Yes |
| Wrap cells in IFERROR | 10 cells per run | Any number |
| Price | $0 | $4 a month, or $29 once |
Pro ($4 a month or $29 once, sold by Polar, our merchant of record) goes on sale when the add-on is live in the Google Workspace Marketplace. Until then nothing can be bought here.
Install from Google Workspace Marketplace (link coming after Google's review)What it can see
Formula Doctor only works on the spreadsheet you have open, and only when you click Scan or a fix button. It cannot open your other files. Your data stays in your file; the only thing sent out is your license key, to Polar, to check it. Details are in the privacy policy.
Prefer to do it by hand? Our guide How to find every formula error in Google Sheets shows three free formulas.
© Lumineus Studio. Write to [email protected] with questions. Privacy policy