Formula with date, days and checkbox criteria

Dana S

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 you tell me what I'm missing?

=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, "")

Dana S

formula with check box criteria.jpg

I neglected to add an attachment for a visual of the sheet I'm working in.

Paul Newcome

I believe this was already answered on your other post?

https://community.smartsheet.com/discussion/104894/formula-variable-with-checkbox-and-mutli-column-criteria