Formula variable with checkbox and mutli-column criteria
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, "")
Help Article Resources
Check out the Formula Handbook template!