Count projects that will complete in the current month - parent rows only

steven.nienaber105336 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I have a sheet that houses all projects within one department.  Many of the projects have child rows that I don't want to include in my count formula.  I have a Hierarchy column that reflects "0" in the parent rows - those are the only rows I want to count if the date of completion is in the current month.  Help?  

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!