# Once my child dots are all green, is there a formula to automatically turn the parent dot green?

Options

Example:

Parent: Onboarding

Child: I-9

Child: W-4

Child: etc.

Once I mark all the child dots green, I would like for Onboarding to automatically turn green.

• ✭✭✭✭✭✭
Options

oops, I forgot the @row after Status. my bad

=IF(COUNT(CHILDREN([Onboarding Paperwork]@row)) = COUNTIFS(CHILDREN(Status@row), "Green"), "Green", "Red")

• ✭✭✭✭✭✭
edited 11/10/21
Options

Hey @Eric Leon

This formula will turn the Onboarding ball green if all Onboarding children are green. What color would you like the ball to be if all children are not green? As written, I have the Parent Ball be Red if all children are not Green. By counting the children in your primary column (be sure to insert the actual name of your primary column) you will be certain the total children number is complete.

=IF(COUNT(CHILDREN([Primary column]@row)) = COUNTIFS(CHILDREN(Onboarding@row), "Green"), "Green", "Red")

Are the child balls turned by formula, or do you change the color manually? If the children balls are changed by formula, what formula are you using? We can combine the two so that all changes would then be automatic.

Kelly

• Options

Thank you @Kelly Moore !

All balls will start off Red, and team will manually change the Children to Green balls once task is complete. The hopeful outcome once all Children balls are complete, the Parent ball will automatically change to Green.

• ✭✭✭✭✭✭
Options

Great!

To edit the formula above to match your columns, the formula you are inserting in the parent rows of the Status column is:

=IF(COUNT(CHILDREN([Onboarding Paperwork]@row)) = COUNTIFS(CHILDREN(Status), "Green"), "Green", "Red"

cheers,

Kelly

• edited 11/10/21
Options

Thank you @Kelly Moore ! Still popping up #unparseable However, this is a great start an I think I can figure out what I need to do. Thank you!

• ✭✭✭✭✭✭
Options

oops, I forgot the @row after Status. my bad

=IF(COUNT(CHILDREN([Onboarding Paperwork]@row)) = COUNTIFS(CHILDREN(Status@row), "Green"), "Green", "Red")

• Options

Appreciate you rechecking!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!