Helper columns vs #UNPARSEABLE error


This works for me using helper columns where I do count(parent) and count(children)

=IF(OR(children18 = 0, Parent18 > 0), 1, 0)

If I substitute the count(children) its #UNPARSEABLE

=IF(OR(count(children) = 0, Parent18 > 0), 1, 0)

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!