Avgerages, assigning a value to text, and parent/child formula

JARED AMOTH

I'm attempting to insert a formula into parent rows that assign a % complete based on entries on child rows. The child rows responses are locked based on task completion. The options are: "Yes, In-Process, and Not Started."

I've made these two stand-alone formulas that I "think" will work, but I can't get them to play nicely.

=IF(Complete@row = "Yes", 1, IF(Complete@row = "In-Process", .5, IF(Complete@row = "Not Started", 0)))

 =AVG(CHILDREN([Complete]@row))

Thanks in advance!

Paul Newcome

Where are you wanting to put the AVG formula?

JARED AMOTH

I want to insert the formula in the parent row & have it create averages of the child rows. Does that make sense?

Paul Newcome

In the same column as the IF statement? If so, try:

=AVG(CHILDREN())

JARED AMOTH

It's in the same column, but the child responses are text. I'd need to convert the responses into numbers for the formula to work.

Paul Newcome

Your IF formula is outputting numbers already though. I'm not sure I understand what the problem is.

You have an IF formula in [Column XYZ] and you want to get the average of the children in [Column XYZ], so you should be able to put the =AVG(CHILDREN()) in the parent rows of [Column XYZ] since the child rows should have numbers in them.