I am trying to set a value of a field based on the value of two others fields. I am having trouble formating it properly in monday, also not sure if i should and a Nested IF or SWITCH statement
Basicly, PRIORITY field is defined based on the value EFFORTS and IMPACT
My set of conditions are:
IF Effort = 3 AND Impact = 1:
Priority = "Very Low"
IF Effort = 3 AND Impact = 2:
Priority = "Low"
IF Effort = 3 AND Impact = 3:
Priority = "Moderate"
IF Effort = 2 AND Impact = 1:
Priority = "Low"
IF Effort = 2 AND Impact = 2:
Priority = "Moderate"
IF Effort = 2 AND Impact = 3:
Priority = "High"
IF Effort = 1 AND Impact = 1:
Priority = "Moderate"
IF Effort = 1 AND Impact = 2:
Priority = "High"
IF Effort = 1 AND Impact = 3:
Priority = "Very High"
Anyone can help ? I cant seem to figure out the syntax…
Welcome to the community. I can’t answer exactly as there are some issues with your definitions. The lost 3 rows all have the same input but generate different output. To generalize (and maybe make thing a little easier): can’t you define values for effort and impact in such way that multiplying the two gives a single number that defines the priority.