"I currently have a Parent Child Sheet that goes down 3 Levels, in one of my columns I have number v
"I currently have a Parent Child Sheet that goes down 3 Levels, in one of my columns I have number values and I want to take the Average of the 3 values but I'm having issues incorporating the Level / Indent Field using the "IF" formula, I also don't know if this is better to user "Ancestors" or "Children". For now at the Level 2 entry I have this "=AVG(CHILDREN())", but I need I would prefer a column Formula where I could say IF Row Level 1 has Ancestors or kids then perform an average. I want to create a new column for this formula
"
Answers

You can create a helper column to get the level. The formula you can use is =COUNT(ANCESTORS([Primary Column]@row)). This will give you 0 as a value for the parent, 1 for the child, and 2 for the grandchild. You can then use this helper column in your formula to get different average values.
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!