IFERROR not working

Paul Newcome

Ok. And can you provide a screenshot of the column settings for the [Task Status] column? The particular error that is being generated is what is throwing me off.

Jeana

Paul Newcome

Let's try this...

=IFERROR(INDEX(CHILDREN([Task Steps]@row), COUNTIFS(CHILDREN([Task Started]@row), <> "")), "")

Jeana

Hhmmmmm....this formula still calculates the Task Status correctly but when there are not dates in the children Task Done cells I still get the error. It's referencing the parent row for dates.

Paul Newcome

What do you mean by your last statement of

"It's referencing the parent row for dates."

Paul Newcome

I have another idea...

=IF(COUNTIFS(CHILDREN([Task Started]@row), <> "") = 0, "", INDEX(CHILDREN([Task Steps]@row), COUNTIFS(CHILDREN([Task Started]@row), <> "")))

Jeana

THANK YOU!!!! That worked. Now the field is blank unless dates are entered. Just what I needed. Appreciate it sssoooo much!

Jeana

Paul Newcome

Great!! Happy to help! 👍️

To explain how it works... Instead of trying to do the calculation and account for an error, we first counted the cells that are not blank. If that count is zero (all cell are blank), we generate a blank. This means that it will not run the error causing portion until there is at least one date, and as long as you have at least one date, there is no error to worry about.