Calculate the value of Readiness(single select field)

Question

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_0av1h6 · Accepted Answer

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.

Gaurav_0av1h6 · Accepted Answer

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.