How do I Check/Uncheck Parent if at least 1 Child is checked?


I have been using this formula:

=IF(COUNTIFS(CHILDREN(), <>0), 1, 0) but if more that one child is checked in the column it comes up with #INVALID DATA TYPE .

How can i fix this. The requirement is at least one Child row must be checked for parent row to be true if not false.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!