IF Function

Evaluates a logical expression and returns one value when true or another when false.
Sample Usage
IF([Due Date]1 > [Due Date]2, "Date 1 is Larger", "Date 2 is Larger")
Syntax
IF(
  • logical_expression
  • value_if_true
  • [
    value_if_false
    ]
)
  • logical_expression
    The expression to evaluate. Must be true or false.
  • value_if_true
    The value or formula to return if the logical expression is true.
  • value_if_false
    —[optional]
    The value or formula to return if the logical expression is false. If omitted, a blank value is returned.
Usage Notes
  • You can nest IF functions to perform multiple logical evaluations. 
  • Smartsheet reads the IF statements in the formula from left to right, displaying a value based on the first expression to evaluate to true. When nesting IF functions, the optional return_if_false will be returned only if all logical expressions evaluate to false.
Examples

This example references the following sheet information:

Row #

Item Number

Status

Order Date

In Stock?

1

C001

Green

12/15/19

true

2

C002

Red

12/12/19

false

3

C003

Yellow

12/15/19

true

4

C004

Green

12/20/19

true

 

Given the table above, here are some examples of using an IF() function in a sheet:

 

Formula

Description

Result

=IF([Status]1 = "Red", "At Risk", "On Time")

IF the ‘Status’ column row 1 equals “Red”, return the value "At-Risk”, if not return the value “On-Time”.

On-Time

=IF([Order Date]2<TODAY(), “Red”, IF([Order Date]2>TODAY(), “Yellow”,IF([Order Date]2=TODAY(), “Green”)))

IF the “Order Date” column row 2 is less than TODAY return a “Red” value. IF the “Order Date” column row 2 is greater than TODAY return a “Yellow” value. IF the “Order Date” column row 2 equals TODAY return a “Green” value.

Red

=IF([Order Date]3 < TODAY(), "Red", IF(AND([Order Date]3 >= TODAY(), [Order Date]3 < TODAY(+7)), "Yellow", "Green"))

IF the “Order Date” column row 3 is less than TODAY return a “Red” value. IF the “Order Date” column row 2 is greater than or equal to TODAY, AND less than the next 7 days, return a “Yellow” value. If neither applies return the value “Green”.

Yellow

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.

Ask the Community