-
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 |
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.