Formula on Grand Parents row
Hi everyone,
Please I do not know what I am doing wrong with my formula on % complete column, I have intention of calculating average on a grand parent 'the first row' which has other parents as indent.
I used the formula
=AVG(CHILDREN([Days to due Date]@row))
It is giving me above 1000%. please what do I do?
Ps: I do not know if the formula is appropriate. It is the same I used on parent rows and it works well.
Best Answer
-
Hi @Abiola
Hope you are fine, if you want the formula to resident in the parent row of [Days to due Date] column to calculate the CHILDREN AVG then try the following formula:
=AVG(CHILDREN())
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Abiola
Hope you are fine, if you want the formula to resident in the parent row of [Days to due Date] column to calculate the CHILDREN AVG then try the following formula:
=AVG(CHILDREN())
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
-
Excellent, i will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!