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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!