Formula Help: Completed Project Count for Parent Rows Only
I am new to SmartSheet, and I am trying to create a formula that adds up the total number of projects that have a check mark in a Completed column.
Note: I created a row to star all of the projects in parent rows (to distinguish from tasks in the children rows). So essentially, I want to add up all of the starred projects that have a check mark in the Completed column. Any help is greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!