-
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.
- 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.
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 |
| =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.