how to leave the optional rows out, so they don't impact the parent row completion rate

Shuai Yao

Hi Community,

As displayed in the picture, we don't need any actions of the optional rows for now, but i feel like it impacts the completion rate of the parent row. The formula of the completion rate is embedded in Smartsheet , I don't think I can't change it, show as picture 2. Is there a way to make those optional rows not included in the parent row completion?

Thank you!

SoS | Dan Palenchar

Hello @Shuai Yao ,

It is not possible to modify the built in (project settings enabled). % complete column. However, you can make a different % Complete column not linked to the project settings and add a custom formula using logical functions to only consider fields that are required. You will need a column that denotes a field being optional and/or required to use in that formula.