Parent and child rows

Mr. Robinson

Hello,

I need assistance with managing parent and child rows in Smartsheet. How can I display a milestone as completed once all of its child rows are marked as 100% complete? For example, if I complete all the rows under Milestone 5, how can I set Milestone 5 to show 100%? Thank you in advance for your help.

Paul Newcome

If you set your % Complete column as the column to use in the project settings, the parent row should be updated automatically.

jmyzk_cloudsmart_jp

Hi @Mr. Robinson

You can use the "parent rollup functionality."

Please check the similar post for this discussion.

https://community.smartsheet.com/discussion/134589/showing-start-end-and-duration-at-top-of-project

https://app.smartsheet.com/b/publish?EQBCT=976c13e60cb3469d842c53201e9388f0

Please make sure you set the % Complete column options.

Paul Newcome

If you set your % Complete column as the column to use in the project settings, the parent row should be updated automatically.

Mr. Robinson

Thank, you @Paul Newcome

Paul Newcome

Happy to help. 👍️