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

Oliver Berning

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

Paul McGuinness

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