Change the overall project status to "complete" if multiple conditions are met
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!
Best Answer
-
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")
Answers
-
What are the other statuses?
-
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
-
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 Nelson, That worked as well! I appreciate the help
-
Happy to help! 👍️
-
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.
-
@Jessica Kamatam Are you using indentation? What is the formula you are currently using in the header fields? Where will this new field reside?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!