Percentage Complete Parent/Child

Options

I have several child rows that are marked either Assigned or Completed. I need the parent row to tell me what the percentage complete is.

So somehow counting the total number of total child rows and then counting the number of Assigned rows and the number of Completed rows then given me a percentage of Assigned rows.

How do I do that?

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    edited 05/11/22 Answer ✓
    Options

    @jyoung_autosoftdms

    For Augusta Hohbach column:

    =COUNTIF(CHILDREN([Augusta Hohbach]@row), ="Assigned") / COUNT(CHILDREN([Augusta Hohbach]@row))

    For African Grant column:

    =COUNTIF(CHILDREN([African Grant]@row), ="Assigned") / COUNT(CHILDREN([African Grant]@row))

    For Taylor Rivera column:

    =COUNTIF(CHILDREN([Taylor Rivera]@row), ="Assigned") / COUNT(CHILDREN([Taylor Rivera]@row))

    Make sure these three columns are set as percentage so your formula will display a percentage. It wont affect the drop down selections any, just the number value of your formulas.

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!