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.

Show Value Sum of total Parent Rows checked.

Laura
Laura ✭✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

I've researched this and cant find a solution. 

 

How can I set up a CountIf formula for ONLY if Parent Rows are checked in an entire sheet? I can do this for the children rows but cant figure out how to do it only for Parent rows.

 

Also, Can I place this formula on the checkbox column (at the very top for a total) and show a value? 

 

Thanks in Advance

Comments

  • Marcus Odum
    Marcus Odum ✭✭✭✭

    you can create a checkbox column that validates the parent row:

    1. Create a column called vParent (lock it)
    2. enter the following formula:
      • =IF(COUNT(CHILDREN()) > 0,1,0)

    this will enter a check if the the row has children. Now in your summary cell you can enter 

    =COUNTIF(vParent:vParent,1)

     

This discussion has been closed.