#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# % Calculations On children

Options
edited 12/09/19

HI Community

I have A Quick Question On % Calculations

I have a Payment Sechdule Which has a a main Name For example Wall Framing

Under Wall Framing i have indent Wall framing on Floor 1, Floor 2 etc,

And i ran  =SUM(CHILDREN()) To calculate Total We charge on Wall framing

Now For my customer i want to send only The Main Row Which Shows Totals only

But we recevie from our Managers on site % Completed and it calculates Sechdule bt the floor level *% recevied from Our mangers and it totals Very nicly

my only Issue is that when it totals all the  CHILDREN by %

Let say for example our mangers replied on 1st and 2nd Floors were done with 100% and on 3rd and 4th its 0%  so the total in my quickbooks stayeds on all floors completion 50%  but on smart sheet it will calculate it self as 200%?

is their a way to Correct it phrapes by using a Diferent Function etc?

Tags:

• Employee
edited 02/13/17
Options

Hello,

It sounds like you're manually attempting to calculate % complete in the parent rows of your sheets. I'd recommend using our dependencies functionality, which will calculate a weighted percent complete in the parent—this is rolled up from the children based on their percent complete and the duration. More information on this is available in our Help Center: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Complete

Otherwise, you'll need to change your =SUM(CHILDREN()) formula to add caluclations for a weighted % complete.

• edited 02/13/17
Options

how dose weighted % complete.? work what is the formuila

This discussion has been closed.