Nested "IF" Formula Help
Hi all, I feel like I'm close but continue to get #UNPARSEABLE or #SYNTAX errors.
The Formula:
=IF(OR([Project Status]66 = "Training", [Project Status]66 = "Doc Control Released"), "Released", "Development"), IF([Project Status]66 = "Not Started", "Not Started", "")
The Project Status column is a single select drop down with 8 choices. If the user selects either Training or Doc Control Released the result should be Released. If it is any of the other options the result should be Development. I have been able to create this successfully. What I am failing at, is I want the formula to also check for "Not Started" (or blank cell would be better) and return Not Started if this is the case. The italic portion.
Any help is appreciated.
Answers
-
=IF((OR([Project Status]@Row = "Training", [Project Status]@Row = "Doc Control Released"), "Released", IF(OR([Project Status]@Row = "Not Started", ISNULL(Project Status]@Row), "Not Started", "Development"))
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!