- value
- value—The value, typically within a cell, to check
- This function is typically used inside of another function (e.g., IF, COUNTIF, or SUMIF)
ISBOOLEAN is most useful when evaluating if a checkbox column has something else written in it.
It's asking if something else has been typed in there other than a checkbox, 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
If any checkboxes in the range have a text value, set the flag to red. This could be used to trigger alerts or update requests if a non-boolean value is entered into a field.
=COUNTIF([Check1]@row:[Check3]@row, NOT(ISBOOLEAN(@cell))) > 0
Still need help?
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.