GETPIVOTDATA

GETPIVOTDATA helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter the function quickly, use flexible parameters for different calculation scenarios, and keep results updated automatically when source data changes. With GETPIVOTDATA, you can write formulas directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use cross-sheet references, and build nested calculations. If a result is incorrect, you can check formula syntax, parameter count and types, unmatched parentheses, missing commas, text-formatted numbers, or circular references, and manually trigger recalculation when needed. Whether you're creating formulas for routine analysis or troubleshooting errors in existing calculations, GETPIVOTDATA helps you work efficiently. Choose the documentation below that best matches your needs to learn more.

1:53