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


Best Answer

  • Megan Ryzenga
    Megan Ryzenga ✭✭✭
    Answer ✓
    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!