Parent row to give a percentage when Child rows below are populated


Hello All

Can anyone help me with a formula for my parent row below. I need to work out what percentage of days in a week I have booked out for our staff on projects.

Currently I do this manually. As the only formula I have found have been for Tick boxes or completed tasks.

The jobs are selected from a drop down list and the column is set to be a %


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!