Need a advise.
I have created a Formula field that supposes to return the Text value. However I am getting the error
Incorrect parameter type for function 'AND()'. Expected Boolean, received Text.
Based on Priority and Escalated selection this formula should show the value (shown on the right side).
Priority is a picklist field and Escalated is a Checkbox field.
- Priority = High and Escalated = true > P1 - Escalated High
- Priority = High and Escalated = false > P2 - High
- Priority = Medium and Escalated = true > P3 - Escalated Medium
- Priority = Low and Escalated = true > P4 - Escalated Low
- Priority = Medium and Escalated = false > P5 - Medium
- Priority = Low and Escalated = false > P6 - Low
IF(
AND(
ISPICKVAL(Priority, "High"),
IsEscalated,
"True",
"P1 - Escalated High",
(IF(
AND(
ISPICKVAL(Priority, "High"),
IsEscalated,
"False",
"P2 - High",
(IF(
AND(
ISPICKVAL(Priority, "Medium"),
IsEscalated,
"True",
"P3 - Escalated Medium",
(IF(
AND(
ISPICKVAL(Priority, "Medium"),
IsEscalated,
"False",
"P5 - Medium",
(IF(
AND(
ISPICKVAL(Priority, "Low"),
IsEscalated,
"True",
"P4 - Escalated Low",
(IF(
AND(
ISPICKVAL(Priority, "Low"),
IsEscalated,
"False",
"P6 - Low"
)
))
)
))
)
))
)
))
)
))
)
)