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

Taylor Riley

Hi!

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:

•Complete

•No Work Required

•Assessment Completed:Standard

•Assessment Completed:Non-Standard

•Reviewed: No Action Required From Team

•ISBLANK

IF NOT, Return "In Progress"

Is this possible?

Appreciate any help!

Paul Newcome

So basically if there is at least one row that contains one of the three below, then it is "In Progress", otherwise it is "Complete"?

Pending Review

Office Hours Required

Follow-Up Questions: Response Needed

=IF(OR(CONTAINS("Pending", CHILDREN()), CONTAINS("Office", CHILDREN()), CONTAINS("Follow", CHILDREN())), "In Progress", "Complete")

Paul Newcome

What are the other statuses?

Taylor Riley

The complete dropdown list is:

Pending Review

Assessment Completed: Standard

Assessment Completed:Non-Standard

Office Hours Required

Reviewed: No Action Required From Team

Follow-Up Questions: Response Needed

Complete

Not Required

Paul Newcome

So basically if there is at least one row that contains one of the three below, then it is "In Progress", otherwise it is "Complete"?

Pending Review

Office Hours Required

Follow-Up Questions: Response Needed

=IF(OR(CONTAINS("Pending", CHILDREN()), CONTAINS("Office", CHILDREN()), CONTAINS("Follow", CHILDREN())), "In Progress", "Complete")

Taylor Riley

@Paul Nelson, That worked as well! I appreciate the help

Paul Newcome

Happy to help! 👍️

Jessica Kamatam

Hi,

I have few fields in my project plan which are basically headers that have a formula and the status changes to "Complete" "In Progress" etc based what has been selected in the fields below.

I made another field called "Over all status" where i want a formula that can automatically change to "Complete" if all the header fields are "Complete", "In Progress" if any of the header fields are "In Progress", "Not Started" if any of the header fields are "Not Started".

Could someone help me with this pls.

Thank you.

Paul Newcome

@Jessica Kamatam Are you using indentation? What is the formula you are currently using in the header fields? Where will this new field reside?