Formula for calculating priority based on Eisenhower matrix?

Hi community, I’m really ashamed about this question, but I cannot seem to be able to find a solution on my own, sooo, hope you can help me out…

Basically we have a board that has “Urgent?” and “Important?” columns and a priority column which is where we’re trying to set the formula up.

Urgent + Important = High
Urgent + less important or less urgent + important = Medium
Less urgent + Less important = Low

Any support or guidance will be highly appreciated,

Thanks <3

@MondayNewby

Here’s how I would do it:

SWITCH({Urgent?}&{Important?}, 
"UrgentImportant", "High",
"UrgentLess Important", "Medium", 
"Less UrgentImportant", "Medium",
"Less UrgentLess Important", "Low","")

Jim - Subscribe to The Monday Man
Watch Our Latest Video: HELP!!

Wow, I was so lost, but I just learned a lot with that @JCorrell, thanks a lot!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.