Require if formula for Met and not met

[exceluser9]

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.


[TABLE="width: 2129"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column F[/TD]
[TD]Golumn G[/TD]
[TD]Column H[/TD]
[TD]Column I[/TD]
[TD]Column J[/TD]
[TD]Column K[/TD]
[TD]Column L[/TD]
[TD]Column M[/TD]
[TD]Column N[/TD]
[/TR]
[TR]
[TD]Launch date[/TD]
[TD]Completed date[/TD]
[TD]1st email[/TD]
[TD]2nd email[/TD]
[TD]Escalation[/TD]
[TD]Status[/TD]
[TD]Completed date[/TD]
[TD]1st email sent date[/TD]
[TD]SLA for 1st email sent (Expected result)[/TD]
[TD]2nd email[/TD]
[TD]SLA for 2nd email sent (Expected result)[/TD]
[TD]SLA for escalation (Expected result)[/TD]
[TD]SLA for completed (Expected result)[/TD]
[/TR]
[TR]
[TD]12-06-2019[/TD]
[TD]25-05-2019[/TD]
[TD]14-05-2019[/TD]
[TD]17-05-2019[/TD]
[TD]24-05-2019[/TD]
[TD]Pending[/TD]
[TD]24-05-2019[/TD]
[TD]17-05-2019[/TD]
[TD]Not Met[/TD]
[TD]22-05-2019[/TD]
[TD]Not Met[/TD]
[TD]Not Met[/TD]
[TD]Met[/TD]
[/TR]
[TR]
[TD]12-06-2019[/TD]
[TD]15-05-2019[/TD]
[TD]14-05-2019[/TD]
[TD]18-05-2019[/TD]
[TD]16-05-2019[/TD]
[TD]Completed[/TD]
[TD]16-06-2019[/TD]
[TD]17-05-2019[/TD]
[TD]Not Met[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Not Met[/TD]
[/TR]
[TR]
[TD]12-06-2019[/TD]
[TD]24-05-2019[/TD]
[TD]14-05-2019[/TD]
[TD]17-05-2019[/TD]
[TD]23-05-2019[/TD]
[TD]Pending[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Not Met[/TD]
[TD]22-05-2019[/TD]
[TD]Not Met[/TD]
[TD]Not Met[/TD]
[TD]Not Met[/TD]
[/TR]
[TR]
[TD]12-06-2019[/TD]
[TD]15-05-2019[/TD]
[TD]14-05-2019[/TD]
[TD] [/TD]
[TD]16-05-2019[/TD]
[TD]Pending[/TD]
[TD] [/TD]
[TD]17-05-2019[/TD]
[TD]Not Met[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Not Met[/TD]
[/TR]
[TR]
[TD]12-06-2019[/TD]
[TD]10-08-2019[/TD]
[TD]31/06/2019[/TD]
[TD]01-07-2019[/TD]
[TD]07-07-2019[/TD]
[TD]Pending[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Within SLA[/TD]
[TD] [/TD]
[TD]Within SLA[/TD]
[TD]Within SLA[/TD]
[TD]Within SLA[/TD]
[/TR]
[TR]
[TD]12-06-2019[/TD]
[TD]24-05-2019[/TD]
[TD]14-05-2019[/TD]
[TD]18-05-2019[/TD]
[TD]23-05-2019[/TD]
[TD]Completed[/TD]
[TD]25-05-2019[/TD]
[TD]17-05-2019[/TD]
[TD]Not Met[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Not Met[/TD]
[/TR]
[TR]
[TD]12-06-2019[/TD]
[TD]05-06-2019[/TD]
[TD]06-06-2019[/TD]
[TD]11-06-2019[/TD]
[TD]17-06-2019[/TD]
[TD]Pending[/TD]
[TD] [/TD]
[TD]17-05-2019[/TD]
[TD]Met[/TD]
[TD] [/TD]
[TD]Not Met[/TD]
[TD]Not Met[/TD]
[TD]Not Met[/TD]
[/TR]
</tbody>[/TABLE]

 

[sparky2205]

Try these:
Column J: =IF(C3>TODAY(),"Within SLA",IF(OR(I3>C3,I3=""),"Not Met","Met"))
Column L: =IF(OR(G3<>"Pending",D3=""),"",IF(AND(G3="Pending",D3>TODAY()),"Within SLA","Not Met"))
Column N: =IF(B3>TODAY(),"Within SLA",IF(OR(H3>B3,H3=""),"Not Met","Met"))

I'm afraid I can't quite figure out what your looking for in column M.
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.
And
this bit of column N also had me a little confused:
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.
But maybe you can figure those out from the other formulas I've provided or provide some clarification.