ISBOOLEAN Function

Checks whether a value is a boolean (e.g., checkbox, flag, or star)
Sample usage
IF(ISBOOLEAN(Done@row), "Cell contains a boolean value", "Cell doesn’t contain a boolean value")

Syntax

ISBOOLEAN(value)
  • value
    The value, typically within a cell, to check
Usage notes
  • This function is typically used inside of another function (e.g., IF, COUNTIF, or SUMIF)
Examples

ISBOOLEAN is most useful when evaluating if a checkbox column has something else written in it.

It's asking if something other than a checkbox has been typed in there, so it's true if the field is still a checked or unchecked box and false if it's some other text value.

Example 1

Calculate the percent of checkboxes that are checked. Fields with text entered are excluded from the calculation.

=COUNTIF([Check1]@row:[Check3]@row, 1) / COUNTIF([Check1]@row:[Check3]@row, ISBOOLEAN(@cell))

Brandfolder Image
ISBOOLEAN example 1

Example 2

Set the flag to red if any checkboxes in the range have a text value. If a non-boolean value is entered into a field, this could trigger alerts or update requests.

=COUNTIF([Check1]@row:[Check3]@row, NOT(ISBOOLEAN(@cell))) > 0

Brandfolder Image
ISBOOLEAN example 2

Still need help?

If you have an Enterprise plan, you can use AI to help write and troubleshoot formulas.

Use the Formula Handbook template to find more support resources and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

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

Was this article helpful?
YesNo