Calculate % Planned in parent row
Options
System
Employee
This discussion was created from comments split from: Calculating Actual Progress vs Planned Progress base on Today's Month & Year.
Answers
-
Please help to calculate the % Planed in Summary row.
Thanks in advance
-
Hi @Md Ariful Islam,
Your formula looks correct to me:
=AVG(CHILDREN())
Is it not behaving the way that you want?
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.
-
@Md Ariful Islam Are you getting an error or an unexpected output? How exactly are the child rows being populated?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!