exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi Team,
I have below data and require formula in column J,L,M&N.
If the column I is <= column C then it should say met & if its greater then not met if the date is in future then it should say Within SLA.
If column G is pending and the column C date is in future then it should say within SLA with the date is in past then it should say not met.
If column K date is within column F then it then column M should say met and if its past the it should say not met and if column F date is in future then it should say Within SLA.
If column H is <= B then it should say met in column N & if its greater it should say not met. If column B date is in future it should say Within SLA. and if the date in column B is in future and if column H date is before date and completed and then should day Met.
Thanks for your support.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have below data and require formula in column J,L,M&N.
If the column I is <= column C then it should say met & if its greater then not met if the date is in future then it should say Within SLA.
If column G is pending and the column C date is in future then it should say within SLA with the date is in past then it should say not met.
If column K date is within column F then it then column M should say met and if its past the it should say not met and if column F date is in future then it should say Within SLA.
If column H is <= B then it should say met in column N & if its greater it should say not met. If column B date is in future it should say Within SLA. and if the date in column B is in future and if column H date is before date and completed and then should day Met.
Thanks for your support.
Column A | Column B | Column C | Column D | Column F | Golumn G | Column H | Column I | Column J | Column K | Column L | Column M | Column N |
Launch date | Completed date | 1st email | 2nd email | Escalation | Status | Completed date | 1st email sent date | SLA for 1st email sent (Expected result) | 2nd email | SLA for 2nd email sent (Expected result) | SLA for escalation (Expected result) | SLA for completed (Expected result) |
12-06-2019 | 25-05-2019 | 14-05-2019 | 17-05-2019 | 24-05-2019 | Pending | 24-05-2019 | 17-05-2019 | Not Met | 22-05-2019 | Not Met | Not Met | Met |
12-06-2019 | 15-05-2019 | 14-05-2019 | 18-05-2019 | 16-05-2019 | Completed | 16-06-2019 | 17-05-2019 | Not Met | Not Met | |||
12-06-2019 | 24-05-2019 | 14-05-2019 | 17-05-2019 | 23-05-2019 | Pending | Not Met | 22-05-2019 | Not Met | Not Met | Not Met | ||
12-06-2019 | 15-05-2019 | 14-05-2019 | 16-05-2019 | Pending | 17-05-2019 | Not Met | Not Met | |||||
12-06-2019 | 10-08-2019 | 31/06/2019 | 01-07-2019 | 07-07-2019 | Pending | Within SLA | Within SLA | Within SLA | Within SLA | |||
12-06-2019 | 24-05-2019 | 14-05-2019 | 18-05-2019 | 23-05-2019 | Completed | 25-05-2019 | 17-05-2019 | Not Met | Not Met | |||
12-06-2019 | 05-06-2019 | 06-06-2019 | 11-06-2019 | 17-06-2019 | Pending | 17-05-2019 | Met | Not Met | Not Met | Not Met |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>