Which is the most efficient formula in this case with multiple conditions?
I want to set up a formula that reflects Status in the Parent row. Below are the conditions:
If all CHILDREN tasks are Not Started, then PARENT status is Not Started
If any CHILDREN task is In Progress or Completed, then PARENT status is In Progress
If all CHILDREN tasks are Completed, then PARENT status is Completed
I don't know where to begin. My nested IF statements are getting too long and complicated.
Thank you!
Answers

@Arundhati On the parent row I enter the following formula, the range depends on how many children you have so say that there are only children rows 25, then: =IF(COUNTIF(Status2:Status5, @cell = "Completed") = COUNT(Status2:Status5), "Completed", IF(COUNTIF(Status2:Status5, @cell = "Not Started") = COUNT(Status2:Status5), "Not Started", "In Progress"))

Thanks Razetto. It is returning "In progress" as the response even if all children tasks are Completed. Can you replace @cell with @row in this formula? And could you also explain in words how the formula would read in Smartsheet? Thank you
Help Article Resources
Categories
Check out the Formula Handbook template!