If all children are not blank then enter a phrase

I am having trouble writing a formula that will return the phrase "Completed" in a cell of a parent row if all the children are not blank. If there are some blank cells then it would return "Not Completed".

I am trying to get the word in the parent row in the column "Opera Analysis Code", if all the children have something entered in that column then I want it to enter "Completed".

I managed to get it working for other columns however those columns are either dropdown columns or checkbox columns, can't seem to work it out for text columns.

Any help would be appreciated.

Thanks,

Emma

Screen Shot 2017-04-19 at 18.17.39.png

Find more posts tagged with

Formulas

Comments

Adam Overton

I would give you a more thorough answer, but I'm heading to a meeting.

I think you want something like =IF(COUNTIF(CHILDREN(), ISBLANK(@cell))=0, "Completed", '')

Basically, if all children not blank then Completed.

Emma

Thanks Adam, I'll give that a try.

Emma

Hi Adam

I entered =IF(COUNTIF(CHILDREN(), ISBLANK(@cell))=0, "Completed", ''Not Completed") however got a #UNPARESABLE error unfortunately.

Have I entered anything wrong?

Thanks,

Emma

Adam Overton

It was a short meeting.

=IF(COUNTIF(CHILDREN(), ISBLANK(@cell)) = 0, "Completed", "")