Calculate the value of Readiness(single select field)

[pradeep km]

Hi All,

We have 3 custom fields 'Tech' 'Process' and 'Culture'.
Each field consist of 3 values 'high' 'low' and 'medium'. Same value for all custom fields.
Based on the average value selected on 'Tech' "process' and "culture' automatic value should update on "Readiness" custom field.

[Gaurav · Accepted solution]

Hello @pradeep km 

Based on the excel snapshot, I extended it to cover all the possible value combinations for Tech, Process and Culture; and derived the value for Readiness. Please find below the conditions for this:

Readiness = 1
Tech = Low AND Process = Low AND Culture = Low

Readiness = 2
(Tech = High AND Process = Low AND Culture = Low) OR
(Tech = Medium AND Process = Medium AND Culture = Low) OR
(Tech = Medium AND Process = Low AND Culture in (Medium, Low))

Readiness = 3
(Tech = High AND Process = Medium AND Culture = Low) OR
(Tech = High AND Process = Low AND Culture = Medium) OR
(Tech = Medium AND Process = High AND Culture = Low) OR
(Tech = Medium AND Process = Medium AND Culture = Medium) OR
(Tech = Medium AND Process = Low AND Culture = High) OR
(Tech = Low AND Process = High AND Culture = Medium) OR
(Tech = Low AND Process = Medium AND Culture = High)

Readiness = 4
(Tech = High AND Process = High AND Culture in (Medium, Low)) OR
(Tech = High AND Process = Medium AND Culture = (High, Medium)) OR
(Tech = High AND Process = Low AND Culture = High) OR
(Tech = Medium AND Process = High AND Culture = (High, Medium)) OR
(Tech = Medium AND Process = Medium AND Culture = High) OR
(Tech = Low AND Process = High AND Culture = High)

Readiness = 5
Tech = High AND Process = High AND Culture = High

Let me know if this helps or if you need any further guidance.

KIndly accept the answer if this aligns with the response.

[pradeep km]

Thanks

[Gaurav · Accepted solution]

Hello @pradeep km 

This can be performed using Automation. I have done something similar where I have used Impact and Urgency to define the Priority.

Please find below the screenshot of the same. Let me know if you need help with the exact rule.

Kindly accept the answer if this helps.

[pradeep km]

Hi Gaurav ,

Can you help me for my conditions mentioned above in the attached excel.
Since "readiness" field is text field.
System should consider "high" as '5' and 'low' as '1' and "medium" as '3' from backend and update average value of all custom fields into "Readiness" field as shown in excel file.

Regards,
Pradeep KM