Skip to main content

Hello everyone! Thanks in advance for your time.



I made a table to log tasks, where I put one column for level of complexity (S-small, M-medium, L-large) and another column for volume of work (S-small, M-mediu, L-large). Another third column sums it into SM, SL, SS, MM, LL etc and also sorts it by a custom order.



How can I make a formula for one more column for URGENCE LEVEL, where I can put a formula that says like IF Hierarchy = SS, SM or SL then show the word “HIGH”, then IF Hierarchy = MM or ML, show the word “MODERATE” and IF Hierarchy = LL, then show “LOW”.



Idk, it seems simple, but I advance I am a creative that managed into adulthood without learning many formulas, god only knows how. So after failing the whole afternoon I came to look for your wisdom. Thank you guys for reading me! :grinning_face_with_big_eyes: 

SWITCH(


   {Hierarchy},


   "SS", "HIGH", 


   "SM", "HIGH", 


   "SL", "HIGH", 


   "MM", "MODERATE", 


   "ML", "MODERATE", 


   "LOW"


)

Reply


Terms & Conditions