Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Anyway to have parent automatically get checkmark?

Tyler Wymore
Tyler Wymore ✭
edited 12/09/19 in Archived 2016 Posts

I have a parent row with 5 children rows. Is it possible to set my sheet up to have the parent row automatically get the checkmark after all the children rows have been checked off?

 

Example:

Is there anyway to have Project A auto check since objectives 1-5 are completed?

· Share on FacebookShare on Twitter

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Tyler,

     

    Try this:

     

    =IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), 1), 1, 0)

     

    I hope this helps.

     

    Craig

    · Share on FacebookShare on Twitter
  • Tyler Wymore
    Tyler Wymore ✭

    The first formula "=IF(COUNT(CHILDREN())" gave me the error message "#MISSING"

     

    The second formula "=COUNTIF(CHILDREN(), 1), 1, 0)" gave me the error message "#IMBALANCED"

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Sorry,

     

    It isn't two formulas, it is one.

     

    =IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), 1), 1, 0)

     

    This part checks the number of checked boxes from the children

    COUNTIF(CHILDREN(), 1)

     

    This part counts the number of children (checked or unchecked)

    COUNT(CHILDREN())

     

    The equals sign in the middle determines if they match

     

    =IF(expression,1,0)

     

    will check the parent box if they do, uncheck if they don't.

     

    Craig

     

     

     

     

     

     

     

     

     

     

     

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories