Ranges for status update

Platform discussions Special workflows & use cases
, ,
1

Hello everyone!

I’m trying to build this small formula when, depending on the probability, the priority status gets updated.
For example:
Probability 1-45 = Low Priority
Probability 46-65 = Medium Priority
Probability 66-100 = High Priority

I found another posts regarding this but none of the solutions seems to work. Right now the closest one is this:

IF({Probability}<45, {Priority}=“Low”,
IF(AND({Probability}>=45, {Probability}<=65, {Priority}=“Medium”,
IF({Probability}>65, {Priority}=“High”))))

I can’t make the “Medium” priority to work but the other two function perfectly. Can you help me sort this out?

Thank you!

2

How about this?

IF({Probability}<45, {Priority}="Low",
IF(AND({Probability}>=45, {Probability}<=65), {Priority}="Medium",
IF({Probability}>65, {Priority}="High")))
3

Hello!

No :frowning: “Medium” update still not working.