If Formula

Options
Tony Barthelemy
Tony Barthelemy ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good Day All:

 

I am trying to create the following Formula however I am receiving an  Incorrect Argument:

If impact is High and Influence is High, then the Classification is Key Player

My Formula: =IF(AND([Impact on Project]2 = "High", [Project Influence]2, "High", ="Key Player"))

 

All help appreciated, Thanks!

Tags:

Comments

  • Tony Coleman
    Options

    This work for you?

     

    =IF(AND([Impact on Project]2 = "High", [Project Influence]2 = "High"), "Key Player")

     

  • Tony Barthelemy
    Tony Barthelemy ✭✭✭✭✭
    Options

    All:

    Figured out the formula. No need to reply.

    Thanks

     

  • Tony Barthelemy
    Tony Barthelemy ✭✭✭✭✭
    Options

    Tony:

     

    I just saw your reply, thanks. I also expanded my formula:

    =IF(AND([Impact on Project]2 = "High", [Project Influence]2 = "High"), "Key Player", IF(AND([Impact on Project]2 = "High", [Project Influence]2 = "Low"), "Important Player", IF(AND([Impact on Project]2 = "Low", [Project Influence]2 = "High"), "Affected Player", IF(AND([Impact on Project]2 = "Low", [Project Influence]2 = "Low"), "Potential Player"))))

     

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!