Count Parent rows and rows without children



We have an archive sheet where all completed projects are automatically migrated via "move row" workflow.

Some projects have multiple child rows while some do not have any.

I would need a formula to count a total number of completed projects regardless if they have or do not have child rows. If they have child rows, they only need to be counted once.

In the example below, the total count of completed projects would be 5.

Is there a formula that can count this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!