MarkLindsey✭

Hi Cathy, I think I understand where you're going. See if this works: =IF(COUNT(CHILDREN([Task Name]1)) > 0, SUMIFS(CHILDREN(Duration1), CHILDREN(Finish1), >TODAY(122)), "") To break this down: IF Statement - This is so you only sum on parent rows. You will sum all of the children for that parent. If the cell is a child,…

Hi Cecily, Try this formula: =IF(ISBLANK([Close Date]16), "", NETDAYS(TODAY(), [Close Date]16))

Hi Cathy, Try this formula: =SUMIFS([Resource Duration]7:[Resource Duration]23, Finish7:Finish23, >TODAY(122)) You were missing the comma after the 'Finish' criteria range, and you may want to use '>' instead of '=' for the criteria depending on the results you're looking for. You can also use the built-in TODAY function…

One correction on the "Column" formula. You need to divide by the children count of your "Test Type" column. The correct formula would be: =(COUNTIF(CHILDREN([Subtask Status]10), "Pass")) / (COUNT(CHILDREN([Test Type]10)))

This is basically the same as your previous question. It looks like you've dropped the "Pass" checkbox column, but you can still get the results you want using the following. For the "Column" formula, use: =(COUNTIF(CHILDREN([Subtask Status]10), "Pass")) / (COUNT(CHILDREN([Subtask Status]10))) For the "Status" Column, use:…

My first observation is I don't think you need the "SUM" in the Column formula. Try this: =(COUNTIF(CHILDREN(Passed10), 1)) / (COUNT(CHILDREN(Passed10))) Then for the Status Formula, you can try this: =IF(COUNTIF(CHILDREN(Status10), ="Fail") > 0, "Failed Subtask", IF(Column10 = 1, "Passed", IF(Column10 = 0, "Not Started",…

If you don't care which check box is checked, you can create a hidden column to calculate how many checkboxes are checked. Then use that to drive the Harvey ball. I've named each checkbox column Chk1, Chk2, Chk3, Chk4. I've named the hidden column ChkCount. For the hidden column, use this formula: =COUNTIF([Chk1]1:[Chk4]1,…