I. Intro
ISBLANK and IFBLANK are two functions used to determine whether a cell is blank. The ISBLANK function determines whether the cell is blank and returns TRUE or FALSE. The IFBLANK function evaluates whether a cell is blank and returns a specified value if it is blank.
These functions are commonly used to determine whether there is any content missing. For example, team members can quickly check whether production records were filled in by using the ISBLANK function.
Arguments
ISBLANK(value)
- value: The cell(s) to evaluate whether they're blank.
Note: TRUE is returned if the cell evaluated is blank and FALSE is returned if the cell is not blank.
IFBLANK(value, the return value if blank)
- value: The cell(s) to evaluate whether they're blank. If the cell is not blank, the content in the cell is returned.
- the return value if blank: This value is returned if the cell evaluated is blank.
Note: The IFBLANK function is equivalent to using the IF and ISBLANK functions together.
II. Steps
- Open the base and click the + icon on the right side to create a new field. Enter a field title and select Formula as the field type.
250px|700px|reset
- In the formula editor, enter the ISBLANK or IFBLANK function, select the table or field, and enter the arguments as needed.
III. Use cases
Use ISBLANK to find missing data
Scenario: You want to know if any data is missing while managing orders.
Formula: ISBLANK(order number)
Output: Returns "false" if the order number is not blank, and "true" if it is blank.
250px|700px|reset
250px|700px|reset
Use ISBLANK to indicate task completion
Scenario: Mark orders as "completed" if the delivery time has been filled in, and "in progress" if the delivery time is blank.
Formula: IF(ISBLANK([Delivery date]),"in progress","completed")
250px|700px|reset
250px|700px|reset
Use IFBLANK to fill in missing dates
Scenario: Fill in any blank delivery dates with the current date.
Formula: IFBLANK([Delivery date],NOW())
250px|700px|reset
250px|700px|reset