Count children but only some of them


How should this formula look if I want to only count children that are 'Open'?

="Project stage name - " + COUNT(CHILDREN())

I am using on the parent row in a project risk register so I can collapse stages not reached to focus on the risks for the current stage.

However, some of the risks in the current stage are now closed. This is indicated in a 'Status' column with either open or closed. What changes are required to the formula or teh sheet (yikes) to make the count only of open risks?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!