Once all children are filled with text, parent pulls that text into cell


Working on a cert tracker. It requires the trainee to sign off on tasks then that task parent will auto complete.

I want to check that, once all the children "trainee initials" are filled, it pull that same text into the parent.

I found that =JOIN((DESCENDANTS())) works but it does it for any child that filled. I would like it for ,once all descendants are filled in, to populate. I feel that there should be an AND function but I can't figure out the syntax

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!