I have a requirement that we need to set priority based on category, subcategory and problem type.

[pdurgapavan]

Here problem type is a choice type field and is dependent on subcategory. so, what I'm trying to do is, I created one data lookup definition like below images.

can we also define category, subcategory and priority, impact and urgency like impact, urgency and priority like below

@Community Alums 

@Sohail Khilji

@Sandeep Rajput 

@James Chun 

@Dr Atul G- LNG 

@Abhishek_Thakur 

@Sandeep Dutta 

@Ankur Bawiskar 

@SAI VENKATESH 

@Anurag Tripathi

[Dr Atul G- LNG]

Hi mate,

lets divide this issue in 2 parts

1. Lets create a look up table which set impact and urgency on basis of Cat+ Sub cat+ Issue type

2. when impact + urgency get populated based on step1  then create another lookup or change in OOTB lookup to set new priority as per your requirement.

So now, 1st complete the step1 

means

a. create a new matcher table

b. populate the values in that

c. create a data lookup table where matcher is cat +sub cat+ issue type and setter is Impact+urgency

If it work then 

do same way step2 but make sure OOTB data lookup defination must be deactivated else it create issue.