detect_formula_errors
Detect common formula errors like #DIV/0! and #REF! in Google Sheets, with automatic repair suggestions.
Instructions
Detect formula errors and provide repair suggestions with 99% output reduction
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error_types | No | Types of errors to detect: #DIV/0!, #REF!, #VALUE!, #NAME?, #N/A, #NULL!, #NUM! | |
| target_range | No | Range to check for errors | A1:Z100 |
| suggest_fixes | No | Provide repair suggestions for detected errors | |
| spreadsheet_id | Yes | Google Spreadsheet ID |