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 @pdurgapavan 

You need to create another table which will look up combination of category and sub category like we have for Impact and Urgency. But why you making it so complex mate. 

[pdurgapavan]

Hello @Dr Atul G- LNG ,

Could you please help me how to create table for combination of category, sub category, problem - type like we have for Impact and Urgency.

and also, please suggest me the best way

[Dr Atul G- LNG]

Hi @pdurgapavan 

https://youtu.be/K7L3n3AUYmE

[pdurgapavan]

Hello @Dr Atul G- LNG ,

I tried as per instructions given in the video still impact and urgency is not changing based on category, subcategory and problem type values.

below are images

@Dr Atul G- LNG , could you give me a suggestion where I got wrong?