Two drop down list columns: modify one column if other column matches criteria

I have two columns: Security Level & PW Change Frequency


I'm trying to add a formula in the PW Change Frequency column that will select 1 Month, 3 Months, or 6 Months based on the Security Level.

If Security Level is "HIGH" than PW Change Frequency is "1 Month"

If Security Level is "MEDIUM" than PW Change Frequency is "3 Months"

If Security Level is "LOW" than PW Change Frequency is "6 Months"


This is the formula I have so far, but it is only working when the Security Level is set to "HIGH": =IF(MATCH("HIGH", [Security Level]@row), "1 Month", IF(MATCH("MEDIUM", [Security Level]@row), "3 Months", IF(MATCH("LOW", [Security Level]@row), "6 Months")))


How do I get it to work with the "MEDIUM" and "LOW" Security Levels?


Thank you in advance!

Oliver

Best Answer

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓

    Hi @Oliver Berning

    This formula should deliver what you need, opted for IF function to deliver what you required.

    Tested and working as below.

    Formula is - =IF([Security Level]@row = "High", "1 month", IF([Security Level]@row = "Medium", "3 months", IF([Security Level]@row = "Low", "6 months", "Error")))

    Hope that helps.

    Thanks

    Paul

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!