I want help in achieving the below conditions. can someone please help I have attached the conditions
Hi @Lumjing
You can reduce the formula to like below which will have the same functionality.
Workflow:
Hope this helps : )
@atcodedog05 and @binuacs
sorry but I spend some time working on getting the results for attached input but not getting it can you please help. have attached the data
Start date End date Final
Not Applicable 9/2/2022 9/2/2022
11/3/2022 Not Applicable 11/3/2022
Null Null Null
11/3/2022 9/2/2022 11/3/2022
8/12/2022 9/2/2022 9/2/2022
Not Applicable Null
Not Applicable Null
Start date | End date | Final |
Not Applicable | 9/2/2022 | 9/2/2022 |
11/3/2022 | Not Applicable | 11/3/2022 |
11/3/2022 | 9/2/2022 | 11/3/2022 |
8/12/2022 | 9/2/2022 | 9/2/2022 |
Not Applicable | ||
Not Applicable | ||
11/6/2022 |