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 colu...
  • 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"
)

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , What is logic use

 

One is

 

Switch( True() ,

[Rank] <= 5, "Low",

[Rank] <= 10, "Med",

"High"

)