% Parent Boxes checked

Options

Hello,

I need some help in creating a formula to calculate the % of parent boxes checked -see attachment. In this case I expect the answer to be 25% as only one of the 4 parent boxes is checked.

Any help would be appreciated

Best Answer

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    There may be another way to do this but the way I know is to set up two helper columns. One helper that is checked if the row is a parent row. Another helper with a COUNTIF formula to count the # of parent rows.

    Example sheet:

    Parent Count formula:

    =COUNTIF([Is Parent?]:[Is Parent?], =true)

    % Parent Done formula:

    =COUNTIF(Done:Done, =true) / [Parent Count]@row

    You can hide the "Is Parent?" and "Parent Count" columns after setup but you'll need to manually check the boxes in the "Is Parent?" column.

Answers

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Answer ✓
    Options

    There may be another way to do this but the way I know is to set up two helper columns. One helper that is checked if the row is a parent row. Another helper with a COUNTIF formula to count the # of parent rows.

    Example sheet:

    Parent Count formula:

    =COUNTIF([Is Parent?]:[Is Parent?], =true)

    % Parent Done formula:

    =COUNTIF(Done:Done, =true) / [Parent Count]@row

    You can hide the "Is Parent?" and "Parent Count" columns after setup but you'll need to manually check the boxes in the "Is Parent?" column.

  • Vinton Douglas
    Options

    Much appreciated

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!