% Calculations On children

billing10428

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?

Shaine Greenwood

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.