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, 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!
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!