I need to create dropdown list based on the matrix below:
So that I select the Urgency and the Impact and then the Priority is automatically filled according to the columns below:
And if possible, could I take advantage of and already inherit color formatting from cells?
Could someone help me with this?