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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!