Checks whether a value is blank
Sample Usage
IF(ISBLANK([Task Name]1), "Cell is blank", "Cell isn't blank")
Syntax
ISBLANK(
-
value
- value—The value, typically within a cell, to check.
Usage Notes
- This function is typically used inside of another function, for example: IF, COUNTIF, or SUMIF.
Examples
This example references the following sheet information (some fields have been left intentionally blank):
| Clothing Item | Units Sold | In Stock? | Status | % Complete | |
|---|---|---|---|---|---|
| 1 | T-Shirt | true | Green | 100% | |
| 2 | Pants | 78 | true | Yellow | 25% |
| 3 | Jacket | 42 | false | Red |
Given the table above, here are some examples of using ISBLANK in a sheet:
| Formula | Description | Result |
|---|---|---|
| =IF(ISBLANK([Units Sold]1), "Blank", "Not blank") | Returns the string Blank if row 1 of the Units Sold column contains no value. Otherwise, it returns Not blank. | Blank |
| =IF(NOT(ISBLANK([Units Sold]2)), "Gained revenue","No Sale") | Returns the string Gained revenue if row 2 of the Units Sold column contains a value, and No sale if the field is blank | Gained revenue |
| =IF(ISBLANK([% Complete]3), "Red") | Returns Red if row 3 of the % Complete column is blank | Red |
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.