Hi All New to Smartsheet and having an issue with the % Complete column rolling up to an overall % from the child rows to the parent rows. The child row are attached to the parent row, but only the 1st child row rolls up to show as a % of the parent row. If I add a % into the other child rows linked to the parent row then the parent rows shows 0%. Totally confused, I am sure something simple but I am stuck. If I just take each child line directly below the parent row then it rolls up to show 100% in the parent row. If I add any other lines in then the Parent row shows as 0

I noticed that the Duration column in your sheet is empty. This caused the problem you mentioned. Smartsheet calculates the % Complete and Duration of the parent rows based on the % Complete and Duration of child rows. You should enter values in Start Date, End Date, Duration for this calculation.

Issue with % Complete column rolling up from child rows to parent rows

Answers

Phil.S ✭

06/06/24

Thank you 😀

0 · Share on Facebook Share on Twitter

Trending in Smartsheet Basics

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…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%

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

Watch video

Issue with % Complete column rolling up from child rows to parent rows

Answers

Categories