Question: I’m trying to create a formula in Smartsheet with multiple conditions

SS Questions

Question:

I’m trying to create a formula in Smartsheet for a Date column ("Shipping Deadline") based on multiple conditions:

1. If the "Column B" cell already has a date, keep that value as an answer to this cell. If not then
2. If the "Column A" cell is blank, leave the result blank. If not then
3. If the "Column C" is either "User1" or "User2", subtract 21 days from the "Column A" date.
4. For any other value including blanks in Column C, subtract 16 days from the "Column A" date.

Both "Column A" and "Column B" columns are of Date type.

=IF(NOT(ISBLANK([Column B]@row )), [Column B]@row ,IF(ISBLANK(Column A@row ), "", IF(OR(Column C@row  = "User1", Column C@row  = "User2"),Column A@row  - 21,Column A@row  - 16)))

The above formula gave me an error "Invalid Column Value"

Paul Newcome

Give this a go:

=IF([Column B]@row <> "", [Column B]@row, IF([Column A]@row <> "", [Column A]@row - IF(OR([Column C]@row = "User 1", [Column C]@row = "User 2"), 21, 16)))

Paul Newcome

Give this a go:

=IF([Column B]@row <> "", [Column B]@row, IF([Column A]@row <> "", [Column A]@row - IF(OR([Column C]@row = "User 1", [Column C]@row = "User 2"), 21, 16)))