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
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!