Priority Level Based on Whether a Number is Higher or Lower

Sierra A.
Sierra A.
edited 04/09/24 in Formulas and Functions

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

Tags:

Answers

  • Gillian C
    Gillian C Overachievers

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!