how to automatically set a number to an entry

Leod13
Leod13
edited 09/09/24 in Formulas and Functions

Hi All,

I'm trying to make an equation wherein if I type "Critical" in column 1, column 2 then will automatically assign it as "priority 1"

Best Answer

  • NRJW53
    NRJW53 ✭✭✭
    Answer ✓

    Hi Leod, you could use an if statement for this purpose.

    In column two, use the following formula: =IF(column1@row="Critical","Priority 1",column1@row)

    This will make anything that is Critical in column 1 priority 1 in column 2. If column 1 is not critical, then column 2 will display what is in column 1

Answers

  • NRJW53
    NRJW53 ✭✭✭
    Answer ✓

    Hi Leod, you could use an if statement for this purpose.

    In column two, use the following formula: =IF(column1@row="Critical","Priority 1",column1@row)

    This will make anything that is Critical in column 1 priority 1 in column 2. If column 1 is not critical, then column 2 will display what is in column 1

  • Leod13
    Leod13
    edited 09/09/24

    Thank you, it works. Now, how do I add multiple conditions? I tried this equation below, but it only works at the 2nd condition, "Medium." the 3rd condition shows an error.

    =IF([Fault Severity]@row = "Critical", "1", IF([Fault Severity]@row = "Medium", "2"), IF([Fault Severity]@row = "Low", "3"))

    =IF([Fault Severity]@row = "Critical", "1", [Fault Severity]@row = "Medium", "2", [Fault Severity]@row = "Low", "3")

  • NRJW53
    NRJW53 ✭✭✭

    =IF([Fault Severity]@row = "Critical", "1", IF([Fault Severity]@row = "Medium", "2", IF([Fault Severity]@row = "Low", "3")))

    I think you had an extra parenthesis in there. Let me know if this does not work

  • it worked thank you

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!