What formula can I use to return "Error" if any of the children are blank?

scisar

Hello!

I'm trying to write a formula where if any of the children of a cell are blank, the value returned is "Error". I've done some searching and figured how to return this value if all the children cells are blank, but I want the "Error" value to be returned if even 1 cell is blank.

Thanks in advance for your help!

Deric

=IF(COUNTIF(CHILDREN([Primary Column]1), = "") > 0, "Error")

Deric

=IF(COUNTIF(CHILDREN([Primary Column]1), = "") > 0, "Error")

scisar

Thank you! That worked.