how to calculate % complete

Options

WinaHath

WinaHath ✭✭✭✭

12/08/23 edited 12/08/23 in Formulas and Functions

I need help to calculate % complete based on quantities completed, please and then summarize and calculate % complete for the parent (worksheet)

0 ·

Answers

Paul Newcome Community Champion

12/08/23

For the child rows you would use the completed divided by the total. On the parent rows you would simply use AVG(CHILDREN()).

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Summing Costs under a child row while meeting criteria
I would like to sum costs as I receive invoices from my vendors for the current year, cross referencing another sheet. I cannot get the formula to calculate for the child row. Can someone steer me in the right direction, please?
Help with SUMIFS formula
Hi All The below formula is is returning incorrect argument and i can't figure out why =SUMIFS([Column10]@row :[Column14]@row , [Column10]4, [Today's year]#, [Column10]3, ">=1", [Column14]3, "<=6") I would be very grateful for your help as I appear to be missing something simple?
Sumifs & multi-select dropdown referencing other sheet
I am attempting to get a sum of one column in another sheet if it has the field(s) in the drop down plus a specific branch. I have tried so many variations at this point that I have confused myself. I need some fresh more experienced eyes I think. Current Formula: =SUMIFS({Helper HC}, {Helper Branch}, Branch2, {Helper…