Nested "IF" Formula Help

Options

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

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭
    Options

    =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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!