Formula for Showing Next Task and Owner in the Parent Row

Paul Newcome

It is because you wanted to go by date. Going by how many finish dates are in the past means you will be one short because of the NWF task that has a finish date in December of 2023.

If that was a typo and was supposed to be 2022, then correcting that should get it working again. If it is in fact supposed to be 2023, then you would need to use some logic other than dates that are in the past such as % Complete or Status.

Luke W.

It ended up being a typo, I had the PM verify.

However, that is pushing me to add another condition with some logic with the Status Column.

Essentially, wanting to add the condition if Status is not "Complete" to the formula. I've gotten this far, but it's not working how I'd like...still working on it a bit.

=IFERROR(INDEX(CHILDREN([Task Name]@row), COUNTIFS(CHILDREN(Finish@row), @cell < TODAY(), AND(Status@row), @cell <> "Complete") + 1), "All Tasks Complete")

Paul Newcome

I would suggest not worrying about the date at all and just using "Complete".

=IFERROR(INDEX(CHILDREN([Task Name]@row), COUNTIFS(CHILDREN(Status@row), @cell = "Complete") + 1), "All Tasks Complete")

Luke W.

Ok thank you. I'll give that a go!