Syntax
ISBOOLEAN(value)
- value—The value, typically within a cell, to check
Sample usage
IF(ISBOOLEAN(Done@row), "Cell contains a boolean value", "Cell doesn’t contain a boolean value")
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))
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
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.