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
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?
Comments
-
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.
-
how dose weighted % complete.? work what is the formuila
