Overview
If you're experiencing issues with SAI formulas in SheetXAI, this troubleshooting guide will help you resolve common problems. SAI formulas are powerful AI-driven functions that work in both Google Sheets and Excel.
Quick Start
Most common SAI issues:
- Activate SAI Formula if you see #NAME error
- SAI Transformations Auto-Detect Locale if you get parse errors or formatting issues
SAI Troubleshooting Guides
Activation Issues
- SAI Formula Not Working - #NAME Error: Activate SAI formulas in Google Sheets to fix #NAME errors
Parse and Format Errors
- SAI Transformations Auto-Detect Locale: Locale is auto-detected to prevent parse errors and formatting issues
Formula Builder Issues
- Using the Formula Builder: Learn how to use the Formula Builder (⨍) to create and manage SAI formulas
Understanding SAI Formulas
What are SAI formulas?
- SAI formulas are AI-powered functions that work directly in your spreadsheet cells
- You can use
#SAIcommand format (auto-transforms to formulas) or type formulas directly - If you type native spreadsheet formulas directly, syntax differs by platform — using
#SAIavoids those differences.
Key differences:
- SAI: Refers to the formula functionality
- SheetXAI: Refers to the chatbot assistant
Quick Reference Checklist
Before contacting support, make sure you've tried:
- Activated SAI Formula if using Google Sheets
- Reviewed locale auto-detection if getting parse errors or formatting issues
- Verified you're using the correct syntax for your platform
- Checked that your API keys are configured correctly
- Reviewed error messages for specific guidance
Common SAI Error Messages
| Error | Solution |
|---|---|
| #NAME Error | Activate SAI Formula |
| Parse Error | Locale auto-detection |
| Formula not recognized | Check syntax and activation status |
Still Not Working?
If you've tried all the troubleshooting steps above and the issue persists:
- Document what you've tried: Note which guides you followed
- Take a screenshot of the error message
- Note the exact SAI command you're trying to use
- Check your platform (Google Sheets vs Excel)
- Reach out to support with this information
Contact Support:
- Contact us with screenshots, error messages, and steps you've already tried
Related Resources
Remember: Always activate SAI formulas in Google Sheets first. Locale is auto-detected for transformations, which should eliminate most parse errors.