What formula can I use to return "Error" if any of the children are blank?
Options
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!
Best Answer
-
=IF(COUNTIF(CHILDREN([Primary Column]1), = "") > 0, "Error")
Answers
-
=IF(COUNTIF(CHILDREN([Primary Column]1), = "") > 0, "Error")
-
Thank you! That worked.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!