# IF Formula Creation

Options
✭✭✭✭✭

Having a hard time grouping the portions of the formula correctly. Here are the conditions:

1. If Phase@row = "Phase One" and Status@row <> "Approved by RSA/BU" or "Pre-Existing Solution", then "High"
2. If Phase@row = "Phase Two" and Status@row <> "Approved by RSA/BU" or "Pre-Existing Solution", then "Medium"
3. If none of the above, leave blank

Options

Hi Emily!

Try this:

=IF(AND(Phase@row = "Phase One", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "High", IF(AND(Phase@row = "Phase Two", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "Medium", ""))

Megan Ryzenga | Medical Education Analyst

3M Health Care, Medical Solutions Division

She/Her

Options

Hi Emily!

Try this:

=IF(AND(Phase@row = "Phase One", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "High", IF(AND(Phase@row = "Phase Two", Status@row <> "Approved by RSA/BU", Status@row <> "Pre-Existing Solution"), "Medium", ""))

Megan Ryzenga | Medical Education Analyst

3M Health Care, Medical Solutions Division

She/Her

• ✭✭✭✭✭
Options

@Megan Ryzenga Thank you! This works great :-)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!