Formula to only include status of parent rows and the contact assigned to them


Hi folks,

I'm trying to create a COUNTIFS formula that calculates the number of "In Progress", "Issue/At Risk", "Postponed", and "Complete" statuses that a specific contact has (in this case, the user assigned in the "Lifecycle Lead Column"). The problem I'm having is that I only want to count the parent rows, not the children rows. Is there a logical way to go about this?

I should note that I've also created a helper column and have attached a screenshot of the sheet below for reference. Thanks a bunch for your time.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!