IF / IFERROR

IF tests a logical condition. IFERROR catches formula errors and returns a fallback value instead of showing #NO MATCH or #DIVIDE BY ZERO errors.

Syntax

smartsheet-mastery

=IF(condition, value_if_true, value_if_false) | =IFERROR(formula, fallback)

Example

smartsheet-mastery

=IF([% Complete]@row = 1, "Done", IF([Due Date]@row < TODAY(), "Overdue", "In Progress"))
=IFERROR(VLOOKUP([ID]@row, {Roster}, 2, false), "Not found")
=IFERROR([Budget]@row / [Hours]@row, 0)