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
Tip: Use ISBLANK to guard calculations against empty inputs:
=IF(ISBLANK(A1), 0, A1*B1)
This returns 0 if A1 is empty instead of showing an error or blank result.
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
ISERROR()
Purpose: Returns TRUE if a cell contains any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
Formula to use:
=ISERROR(A1)
Example:
=IF(ISERROR(VLOOKUP(A1,B:C,2,0)), "Not found", VLOOKUP(A1,B:C,2,0))
Use this to prevent errors from displaying when a lookup can't find a match.
ISERR()
Purpose: Returns TRUE for any error except #N/A.
Formula to use:
=ISERR(A1)
Example:
If A1 contains #VALUE! or #REF!
=ISERR(A1) returns TRUE
If A1 contains #N/A
=ISERR(A1) returns FALSE
ISNA()
Purpose: Returns TRUE if a cell contains an #N/A error.
Formula to use:
=ISNA(A1)
Example:
=IF(ISNA(VLOOKUP(A1,B:C,2,0)), "Not found", VLOOKUP(A1,B:C,2,0))
Use this when you specifically want to catch only "not found" results from lookups.
ISREF()
Purpose: Returns TRUE if a value is a valid cell reference.
Formula to use:
=ISREF(A1)
Example:
If A1 is a valid cell reference
=ISREF(A1) returns TRUE
Using information formulas in Dashpivot helps prevent errors, validate user input, and build more reliable and dynamic templates.