Syntax
ISEVEN(number)

number
—The number to evaluate
Units Sold
references a column name1
references the row numberTrue
andFalse
refer to the value to return if the logical expression is true or false. You can label them as you wish.
This ISEVEN function only evaluates the numbers before the decimal place to determine whether these values are even or odd. Decimal values don’t impact the result.
This example references the following sheet information:
Formula  Order Quantity  Result  

1  =ISEVEN([Order Quantity]1)  8  TRUE 
2  =ISEVEN([Order Quantity]2)  15  FALSE 
Let's assume you have a Smartsheet with a column labeled Order Quantity. You want to check if each order quantity is an even number. In this example, let's focus on the value in row 2:
 In row 2, the order quantity is 15.
 You use the formula
=ISEVEN([Order Quantity]2)
 The formula checks whether the value in row 2 of the Order Quantity column is even. Since 15 is odd, the formula returns
FALSE
.
Now, since row 1 has an order quantity of 8, the formula returns TRUE
because 8 is an even number.
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.