Learn the current formula limitations in Dashpivot so you can plan your templates effectively and avoid calculation errors.
Dashpivot formulas are powerful, but there are some limitations to be aware of — particularly when using table cross-referencing.
1. Nested parentheses limitation
Templates using table cross-referencing cannot nest more than one level of parentheses.
For example, formulas like this are not supported:
=FUNCTION((FUNCTION2),(FUNCTION3(FUNCTION4)))
Workarounds:
Break the formula into separate calculations across multiple table cells.
Remove unnecessary parentheses where possible.
Use the
IFS()function instead of deeply nested logic, for example:
=IFS(Condition1, Value1, Condition2, Value2, Condition3, Value3)
2. VLOOKUP and MATCH exact match limitation
Templates using table cross-referencing do not currently support exact match lookups with VLOOKUP() or MATCH().
When building templates that rely on lookups, consider simplifying logic or restructuring data to avoid exact-match dependencies.
Understanding these limitations will help you design more reliable templates and choose alternative formula approaches where needed.