If Formula
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!
Comments
-
This work for you?
=IF(AND([Impact on Project]2 = "High", [Project Influence]2 = "High"), "Key Player")
-
All:
Figured out the formula. No need to reply.
Thanks
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!