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, "")
Answers
-
Try this:
=IF([PSA/Lease Executed]@row = 1, [PSA/Lease Target Date]@row, [PSA/Lease Executed Date]@row) + [DD Period]@row
-
This returned a sytax error. Does it need to be nested IF AND formula?
IF UNCHECKED return PSA/Lease Target Date + DD Period
IF CHECKED return PSA/Lease Executed Datee + Period
-
What error exactly? If you have it set as a column formula, try converting it into a cell formula then entering the new formula so we can see exactly what error it is which should provide some help in troubleshooting.
The formula above says
IF [PSA/Lease Executed]@row is checked, then output [PSA/Lease Target Date]@row, otherwise output [PSA/Lease Executed Date]@row. Then we add [DD Period]@row to whichever date is output by the IF statement.
I do see now where I read it backwards though, but that wouldn't return a syntax error.
Here it is saying that if it is unchecked then output target, otherwise output executed. Then add period.
=IF([PSA/Lease Executed]@row <> 1, [PSA/Lease Target Date]@row, [PSA/Lease Executed Date]@row) + [DD Period]@row
-
It worked. Thank you so much Paul! Have a great weekend.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!