Change the overall project status to "complete" if multiple conditions are met


I'm trying to find the right formula to change the overall project status based on the status of multiple child rows within the same column. I was attempting an If/Or combo, but kept getting the "Unparseable" error.

Set Overall Project Status to "Complete" IF Status2:Status10 include:


•No Work Required

•Assessment Completed:Standard

•Assessment Completed:Non-Standard

•Reviewed: No Action Required From Team


IF NOT, Return "In Progress"

Is this possible?

Appreciate any help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!