Forum Discussion

HansVogelaar's avatar
HansVogelaar
MVP
Feb 25, 2024

Maj786 

Please test carefully:

 

=IFS(COUNTIFS(E13:E15, "Pass")=3, "Pass", COUNTIFS(E13:E15, "Fail")>0, "Fail", COUNTIFS(E13:E15, "Not Run")=3, "Not Run", COUNTIFS(E13:E15, "Blocked")>0, "Blocked", TRUE, "In Progress")

Maj786's avatar
Maj786
Copper Contributor
Feb 25, 2024

HansVogelaar 

 

Thank you for this! Ever so helpful. 

 

What about if i had: 

  • one step that was out of scope and two steps Passed --> i would expect that test case to be Pass 
  • three steps Out of Scope --> i would expect this to make the overall test case status to be out of scope.

 

Also the 3 in statement below, is this the number of steps? The only reason i ask is in case i have to increase the number of steps would this need to be reflected here? 

=IFS(COUNTIFS(E13:E15, "Pass")=3

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 25, 2024

    Maj786 

     

    =IFS(COUNTIFS(E13:E15, "Pass")=3, "Pass", COUNTIFS(E13:E15, "Fail")>0, "Fail", COUNTIFS(E13:E15, "Not Run")=3, "Not Run", COUNTIFS(E13:E15, "Blocked")>0, "Blocked", COUNTIF(E13:E15, "Out of Scope")>=2, "Out of Scope", AND(COUNTIF(E13:E15, "Pass")=2, COUNTIF(E13:E15, "Out of Scope")=1), "Pass", TRUE, "In Progress")

     

    And yes, the 3 is the number of steps.

Resources