Nested "IF" Formula Help
Hi all, I feel like I'm close but continue to get #UNPARSEABLE or #SYNTAX errors.
=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.
Help Article Resources
Check out the Formula Handbook template!