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

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
Multiple Users in Grid
Hello. I am trying to create a tracker where there will be multiple users in a Grid sheet and everyone will be adding in a new line at random and same times. Is there a way I can create it where people's work won't save on top each other? Or is there a live view on Smartsheet where other people can see that someone else is…
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…

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