[Help] Change the value of the value of a parent row depending on the statuses of their children

Hi Everyone,

I've seen many articles about this, but i can't seem to figure out how to do this.

I have a row with the name of the project (PARENT) and, indented in it, rows that are tasks part of that project (CHILDREN).

Also, there's a column called Status, with 3 variables as a dropdown menu:

Awaiting

In Progress

Completed

I need a formula that says:

If everything's in status Awaiting, then "Not started",

If everything's in status Done, then "Completed",

If not, "In progress"

For some reason i can't seem to get this done.

Can someone help me?

Find more posts tagged with

Formulas

Comments

AleDL

I think i did it. Is it

=IF(COUNTIF(CHILDREN(), "Awaiting") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "Done") = COUNT(CHILDREN()), "Completed", "In Progress"))

AleDL

I have a second problem.

Another Status row:

4 Statuses:

-Awaiting

-In Progress

-To Fix

-Done

If everything's "awaiting", "Not Started".

If Everything's either "To Fix" or "Done", Completed

Everything else, In progress.

Can you help me with this?

AleDL

=IF(COUNTIF(CHILDREN(), "Awaiting") = COUNT(CHILDREN()), "Not Started", IF(SUM(COUNTIF(CHILDREN(), "To Fix"), COUNTIF(CHILDREN(), "Okay")) = COUNT(CHILDREN()), "Completed", "In Progress"))

Paul Newcome

Looks like you have it pretty figured out. Well done.

Sign in to join the conversation!

Quick Links

Trending discussions

Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions will…
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…
Pulling in data from 1 sheet to another isn't working with any function.
PMO Template - I want to pull in the Project Name Column from the Project Metadata sheet into my custom Attendance Sheet > Project Name Column. I've tried VLOOKUP, INDEX MATCH, JOIN COLLECT, I've changed parenthesis to brackets. I am new to Smartsheets and can't get anything to work. I've watch videos, followed community…