Combining Formulas to make one big Formula

Options

I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get the result I want however I enjoy the rapidness of using an embedded formula. Does anyone know if it's possible to combine the below formulas into work big formula that I can embed in a cell?


Where Priority is High

=IF(AND(Impact@row = "Critical", Likelihood@row = "Certain"), "High")

=IF(AND(Impact@row = "Significant", Likelihood@row = "Certain"), "High")

=IF(AND(Impact@row = "Critical", Likelihood@row = "Possible"), "High")


Where Priority is Medium

=IF(AND(Impact@row = "Critical", Likelihood@row = "Unlikely"), "Medium")

=IF(AND(Impact@row = "Significant", Likelihood@row = "Possible"), "Medium")

=IF(AND(Impact@row = "Minor", Likelihood@row = "Certain"), "Medium")


Where Priority is Low

=IF(AND(Impact@row = "Minor", Likelihood@row = "Possible"), "Low")

=IF(AND(Impact@row = "Significant", Likelihood@row = "Unlikely"), "Low")

=IF(AND(Impact@row = "Minor", Likelihood@row = "Unlikely"), "Low")

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @Ryan Jared

    =IF(AND(Impact@row = "Critical", Likelihood@row = "Certain"), "High", IF(AND(Impact@row = "Significant", Likelihood@row = "Certain"), "High", IF(AND(Impact@row = "Critical", Likelihood@row = "Possible"), "High", IF(AND(Impact@row = "Critical", Likelihood@row = "Unlikely"), "Medium", IF(AND(Impact@row = "Significant", Likelihood@row = "Possible"), "Medium", IF(AND(Impact@row = "Minor", Likelihood@row = "Certain"), "Medium", IF(AND(Impact@row = "Minor", Likelihood@row = "Possible"), "Low", IF(AND(Impact@row = "Significant", Likelihood@row = "Unlikely"), "Low", IF(AND(Impact@row = "Minor", Likelihood@row = "Unlikely"), "Low", "")))))))))

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    @Ryan Jared

    =IF(AND(Impact@row = "Critical", Likelihood@row = "Certain"), "High", IF(AND(Impact@row = "Significant", Likelihood@row = "Certain"), "High", IF(AND(Impact@row = "Critical", Likelihood@row = "Possible"), "High", IF(AND(Impact@row = "Critical", Likelihood@row = "Unlikely"), "Medium", IF(AND(Impact@row = "Significant", Likelihood@row = "Possible"), "Medium", IF(AND(Impact@row = "Minor", Likelihood@row = "Certain"), "Medium", IF(AND(Impact@row = "Minor", Likelihood@row = "Possible"), "Low", IF(AND(Impact@row = "Significant", Likelihood@row = "Unlikely"), "Low", IF(AND(Impact@row = "Minor", Likelihood@row = "Unlikely"), "Low", "")))))))))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!