Formula variable with checkbox and mutli-column criteria

Options

I am trying to return a date based on several criteria.

IF PSA/Lease Executed box is check, then use PSA/Lease Target Date + DD Period days

IF PSA/Lease Executed box is unchecked, then use PSA/Lease Executed Date + DD Period days

Here is what I tried but it is not correct. Can someone help me with this formula build?

=IF([PSA/Lease Executed]@row, 0, [PSA/Lease Target Date]@row+[DD Period]@row, (IF([PSA/Lease Executed]@row, 1, [PSA/Lease Execution Date]@row+[DD Period]@row, "")


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!