Countif of children cells


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!