ISBLANK Function

Checks whether a value is blank
Sample Usage
IF(ISBLANK([Task Name]1), "Cell is blank", "Cell isn't blank")
  • 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.

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.

Ask the Community