Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to sort tasks by level of complexity x volume of work?

Topic Labels: Formulas
957 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Carolyna_Branda
4 - Data Explorer
4 - Data Explorer

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:

1 Reply 1
SWITCH(
   {Hierarchy},
   "SS", "HIGH", 
   "SM", "HIGH", 
   "SL", "HIGH", 
   "MM", "MODERATE", 
   "ML", "MODERATE", 
   "LOW"
)