Parent Row Average formaule

Gaurav Chauhan

Hi Team,

Can you please suggest how to add the Role up the Avg %s on the Parent row level. Here, all tasks A to D are indented under Project 1 on Smartsheet. Convert to Column formulae has been enabled for % column. Is there a way to get the Avg roll up % on Parent level.

I am aware on how to do that in Reports, but can we do on Sheet.

Paul Newcome

What is the existing formula in the % Column?

Gaurav Chauhan

Hi Paul, Its a simple DIVIDE clubbed with IFERROR to populate the percentages.

SS "Report" have the functionality for Summarizing by columns so I could do it there.

But unsure how the parent row can capture the Avg of the 4 percentages for Project 1 under the % column.

Paul Newcome

You would need an IF statement that looks something along the lines of...

=IF(COUNT(CHILDREN()) = 0, child_row_formula, AVG(CHILDREN()))