Priority Level Based on Whether a Number is Higher or Lower
Hello,
I am trying to write a formula that will calculate priorities as such:
If Live Count = <15,000 return Critical to Priority column
If Live Count = <10,000 return High to Priority column
If Live Count = <5,000 return Moderate to Priority column
If Live Count = >5,000 return Low to Priority column
Answers
-
Hi @Sierra A.
So when you are doing your nested if you need to think about the boundaries of your formula.
On reading the information above I think you are meaning the following?
Critical category is 'Greater than or equal to 15,000'
High category is 'Greater than or equal to 10,000, but less than 15,000'
Moderate category is 'Greater than or equal to 5,000 but less than 10,000'
Low category is 'Less than 5,000'
Assuming that is the case, try the following:
=IF([Live Count]@row >= 15000, "Critical", IF(AND([Live Count]@row >= 10000, [Live Count]@row < 15000), "High", IF(AND([Live Count]@row >= 5000, [Live Count]@row < 10000), "Moderate", "Low")))
-
That worked perfectly thank you!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!