Parent Row; % Complete Roll Up

D_Pham

D_Pham ✭✭

05/30/24 edited 06/01/24 in Smartsheet Basics

Hi I'm using a template and would like to use the % Complete column. How do I get the child tows with % complete to roll up to the parent and calculate the average % complete for the parent row based on child rows. Test example in second screenshot from another template.

Screenshot 2024-05-30 at 10.45.16 AM.png

Screenshot 2024-05-30 at 10.47.56 AM.png

1 ·

Categories

Trending in Smartsheet Basics

Why does Smartsheet add empty rows to sheets? Can this be disabled?
If I delete empty rows on a sheet, after saving and reloading, Smartsheet will add 10 empty rows to the bottom of the sheet. Example: My 66 rows becomes 76 rows (10 empty). 50 rows becomes 60 rows (10 empty). When I use a "Copy Row" automation, Smartsheet adds enough empty rows to ensure the destination sheet has at least…
No option to deselect "notify people" when sharing a sheet?
This discussion was created from comments split from: SmartSheet sharing - a frequently asked question - is there a better way to share items?.
The smartsheet to copy rows to when setting up automation doesn't show up in search
I'm trying to set up an automation to copy rows of a smartsheet into another one with only one trigger and condition. I get to the end to select a smartsheet to copy the rows to and the smartsheet will not come up in the search. I'm set up as admin for both sheets and the new smartsheet I'm copying to was set up last week…

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