Dashpivot offers the following formulas that perform data validation and error checking. The other uses of information formulas are the following:
Error Checking
Data Validation
Formula Construction
Cell Information
Error Prevention
Data Transfer
Make use of the information formulas in Dashpivot to streamline your forms and make processes much easier to track.
Function ID | Description | Syntax | Sample |
| Notes |
ISBLANK | Returns TRUE if the reference to a cell is blank. | ISBLANK(Value) | =ISBLANK(A1) *A1 - all fields Given that, A1 = ““ | Returns text, true (because cell A1 is empty) | TRUE if the cell is empty and FALSE if it contains any data. |
ISEVEN | Returns TRUE if the value is an even integer, or FALSE if the value is odd. | ISEVEN(Value) | =ISEVEN(A1) *A1 - Number field Given that, A1 = 12 | Returns text, true (because cell A1 is an even number) | TRUE if the number is even and FALSE if the number is odd. |
ISLOGICAL | Tests for a logical value (TRUE or FALSE). | ISLOGICAL(Value) | =ISLOGICAL(A1) *A1 - Text field Given that, A1 = “FALSE” | Returns text, true (Because A1 = “FALSE” and FALSE is a logical value) | This is used for logical values, meaning will return TRUE for values “TRUE” and “FALSE”. Numbers, texts, and empty cells will return FALSE. |
ISNONTEXT | Tests if the cell contents are text or numbers, and returns FALSE if the contents are text. | ISNONTEXT(Value) | =ISNONTEXT(A1) *A1 - Text field Given that, A1 = 123 | Returns text, true (Because A1 = “123” and “123” is a number) | True for: numbers, logical values, errors, or empty cells False for texts, or those including texts |
ISNUMBER | Returns TRUE if the value refers to a number. | ISNUMBER(Value) | =ISNUMBER(A1) *A1 - Text field Given that, A1 = 31 | Returns text, true | TRUE if the value is a number and FALSE otherwise |
ISODD | Returns TRUE if the value is odd, or FALSE if the number is even. | ISODD(Value) | =ISODD(A1) *A1 - Number field Given that, A1 = 15 | Returns text, true | TRUE if the number is odd and FALSE if the number is even. |
ISTEXT | Returns TRUE if the cell contents refer to text. | ISTEXT(Value) | =ISTEXT(A1) *A1 - Text field Given that, A1 = “text” | Returns text, true | TRUE if the value is text and FALSE otherwise |