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

Options

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

• ✭✭✭✭✭✭
Answer ✓
Options

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

• ✭✭✭✭✭✭
Answer ✓
Options

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

• Options

That worked perfectly! Thank you so much for your help :D

Oliver

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!