Nesting OR into AND?

Hi All,

I'm wondering if it is possible to nest an "OR" statement into an "AND" statement. In short, Task C requires Task A be "complete" and Task B be one of two statuses.

I'd expect it to work something like this (note, I'm using status names to illustrate the point): =IF(AND(StatusA="Complete", OR(StatusB="In Progress", StatusB="Complete")), "In Progress", "Not Started")

This is throwing errors, though. Is there a trick I'm not getting, or

Any help would be greatly appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!