Countif of children cells

Options

Hello everyone! I got stuck on a formula that I need as KPI to monitor a project. I need a formula similar to the one that appears by default and that shows the percentage of completed task per macro level. In my case, I need it also for the other activity statuses, such as in progress and not started, so that in the end it will show the percentage of tasks with the specified status for each level of the project. Can anyone help with that? Is it possible to do it?

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!