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 NumberStatusOrder DateIn Stock?
1C001Green12/15/19true
2C002Red12/12/19false
3C003Yellow12/15/19true
4C004Green12/20/19true

 

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

 

FormulaDescriptionResult
=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
=IF(COUNTIF([Item Number]:[Item Number], [Item Number]@row) > 1, 1, 0)

Search for duplicates:

IF the "Item Number" column has more than one instance of the current row's Item Number, then check a checkbox on this row.

Otherwise, if there are no duplicates, do not check the checkbox. 

No rows checked

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

Was this article helpful?
YesNo