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.
Was this article helpful?
YesNo