Results 1 to 2 of 2

Thread: Require if formula for Met and not met
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2015
    Posts
    308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Require if formula for Met and not met

    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.


    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

  2. #2
    Board Regular
    Join Date
    Feb 2013
    Posts
    132
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Require if formula for Met and not met

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •