Dashpivot supports Excel-style information functions inside Default Tables and Prefilled Tables. These formulas are commonly used for:
Error checking
Data validation
Conditional logic and formula construction
Cell value testing
Error prevention
ISBLANK()
Purpose: Returns TRUE if a cell is empty.
Formula to use:
=ISBLANK(A1)
Example:
If A1 is empty
=ISBLANK(A1) returns TRUE
If A1 contains any value (text, number, date, etc.)
=ISBLANK(A1) returns FALSE
ISEVEN()
Purpose: Returns TRUE if a number is even.
Formula to use:
=ISEVEN(A1)
Example:
If A1 = 4
=ISEVEN(A1) returns TRUE
If A1 = 5
=ISEVEN(A1) returns FALSE
ISODD()
Purpose: Returns TRUE if a number is odd.
Formula to use:
=ISODD(A1)
Example:
If A1 = 5
=ISODD(A1) returns TRUE
If A1 = 4
=ISODD(A1) returns FALSE
ISNUMBER()
Purpose: Returns TRUE if the value is numeric.
Formula to use:
=ISNUMBER(A1)
Example:
If A1 = 100
=ISNUMBER(A1) returns TRUE
If A1 = "Hello"
=ISNUMBER(A1) returns FALSE
If A1 is empty
=ISNUMBER(A1) returns FALSE
ISTEXT()
Purpose: Returns TRUE if the value is text.
Formula to use:
=ISTEXT(A1)
Example:
If A1 = "Project A"
=ISTEXT(A1) returns TRUE
If A1 = 250
=ISTEXT(A1) returns FALSE
ISNONTEXT()
Purpose: Returns TRUE if the value is not text.
Formula to use:
=ISNONTEXT(A1)
Example:
If A1 = 250
=ISNONTEXT(A1) returns TRUE
If A1 is blank
=ISNONTEXT(A1) returns TRUE
If A1 = "Project A"
=ISNONTEXT(A1) returns FALSE
ISLOGICAL()
Purpose: Returns TRUE if the value is a logical value (TRUE or FALSE).
Formula to use:
=ISLOGICAL(A1)
Example:
If A1 = TRUE
=ISLOGICAL(A1) returns TRUE
If A1 = 10
=ISLOGICAL(A1) returns FALSE
If A1 = "TRUE" (text)
=ISLOGICAL(A1) returns FALSE
Using information formulas in Dashpivot helps prevent errors, validate user input, and build more reliable and dynamic templates.