Avgerages, assigning a value to text, and parent/child formula
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, InProcess, and Not Started."
I've made these two standalone formulas that I "think" will work, but I can't get them to play nicely.
=IF(Complete@row = "Yes", 1, IF(Complete@row = "InProcess", .5, IF(Complete@row = "Not Started", 0)))
=AVG(CHILDREN([Complete]@row))
Thanks in advance!
Answers

Where are you wanting to put the AVG formula?

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

In the same column as the IF statement? If so, try:
=AVG(CHILDREN())

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.

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.
Help Article Resources
Categories
Check out the Formula Handbook template!