Column L44 with groups. ultimately ends up inside an if, but just trying base formula to eliminate everything else. #UNPARSEABLE =CONTAINS("In", CHILDREN(L44)) =CONTAINS("In", CHILDREN(L44@row)) #INVALID COLUMN VALUE =CONTAINS("In", CHILDREN())
Doing project roll up and trying to use the formula below to roll up a complete status. =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", "Not") However, blank cells do not contribute to the COUNT(CHILDREN()), thus if there are three children and someone deletes all values in 3 cells or any non…