Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiple Column, multiple IFS and multiple Returns

Hello All,

I'm am trying to return a text based off of IFS in two columns.  I'm not sure how I go about it.  The "Score Rank" column was fairly easy to do, but I'm not sure about adding another column to the equasion. 

 

Thank you.  

 

 

 

  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    this info is critical, try this:

    Score_Rank = 
SWITCH(
    TRUE(),
    [Type]="Issue", [Type],
    [Probability]<8, "low",
    [Probability]<15, "medium",
   "high"
)

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , What is logic use

     

    One is

     

    Switch( True() ,

    [Rank] <= 5, "Low",

    [Rank] <= 10, "Med",

    "High"

    )

     

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Anonymous 

    try like:

    Column =
    IF(
    [Type]="Issue",
    [Type],
    [Score Rank]
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you for the quick response, but I'm not sure if I'm understanding. 

    This is how I created the Score Rank column:

     

    Score_Rank = IF(AND([Risk score]>=0, [Risk score]<8),"low",
     IF(AND([Risk score]>=8, [Risk score]<15),"medium",
      IF(AND([Risk score]>=15, [Risk score]<30),"high")))
     
    The "score_rank" column I'm trying to populate has to have that, but if "issue" is in the Type column, then I need to return "Issue" instead of low, medium, or high.  
     
    Thank again,
    Mike
     
    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      hi Anonymous 

      this info is critical, try this:

      Score_Rank = 
SWITCH(
    TRUE(),
    [Type]="Issue", [Type],
    [Probability]<8, "low",
    [Probability]<15, "medium",
   "high"
)

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Thank you.  That's got me about 90% there. 

        I should have been more specific with calculation explanation.  If the type is "Issue", then the only value it can return is "Issue"  For "Risk", it follows the below criteria:

        Low = 0-8

        Med = 9-14

        High = 14+

         

        RS

        Mike

        The formula is returning incorrect values for the Score_Rank column. 

        Example of what's its returning:

         

        Type     Prob  Score Rank  Score_Rank

        Risk      9         Medium      Low

        Risk       5