Multiple if statements with AND

Platform discussions
1

I need help with the following formula. Not sure what I am doing wrong.

IF(AND({Impact} = “High Impact”, {Urgency} = “Urgent”), “Priority 1”),
IF(AND({Impact} = “High Impact”, {Urgency} = “Not Urgent”), “Priority 2”),
IF(AND({Impact} = “Low Impact”, {Urgency} = “Urgent”), “Priority 3”),
IF(AND({Impact} = “Low Impact”, {Urgency} = “Not Urgent”), “Priority 4”))

2

Hi @jodi.bray,

You’ve got your parentheses wrong. They don’t belong after “Priority X” but at the end.
Try:

IF(AND({Impact} = "High Impact", {Urgency} = "Urgent"), "Priority 1",
	IF(AND({Impact} = "High Impact", {Urgency} = "Not Urgent"), "Priority 2",
		IF(AND({Impact} = "Low Impact", {Urgency} = "Urgent"), "Priority 3",
			IF(AND({Impact} = "Low Impact", {Urgency} = "Not Urgent"), "Priority 4")
		)
	)
)