% Complete Incorrect Calc

Bridget Jones

Bridget Jones ✭✭✭✭

02/05/21 in Smartsheet Basics

Hello,

The % complete in the parent row is not calculating correctly the summary of the children rows. Please help.

Thank you,

Bridget

Screen Shot 2021-02-05 at 6.19.48 AM.png

Screen Shot 2021-02-05 at 6.19.58 AM.png

0 ·

Answers

Dan Eshleman ✭✭✭

02/05/21

Make sure all your rows are shown as Child to the Parent. It is hard to tell from the image, but it appears that only one is set as the Child to the Parent and both are showing 0%

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Dashboard Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…

Help shape the future of Smartsheet.
Share your ideas and feature requests.