ISEVEN Function | Smartsheet Learning Center

Checks whether a number is even. Note that this function only works with whole numbers. If a value is even, this function returns "True." If the value is odd, this function returns "False."

Syntax

ISEVEN(number)

number—

The number to evaluate

Sample usage

IF(ISEVEN([Units Sold]1),"True","False")

Usage notes

Units Sold references a column name
1 references the row number
True and False refer to the value to return if the logical expression is true or false. You can label them as you wish.

Examples

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.

Ask the Community