Skip to content
  • Try Smartsheet

    • Archived 2016 Posts

    Archived 2016 Posts

    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?

    ✭✭
    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

    Sign in
    Try Smartsheet

    Comments

    • ✭✭✭✭✭✭

      Tyler,

       

      Try this:

       

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

       

      I hope this helps.

       

      Craig

      · Share on FacebookShare on Twitter
    • ✭✭

      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
    • ✭✭✭✭✭✭

      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.

    Quick Links

    Categories

    Trending Posts