Rolling up end dates to parent rows, excluding completed items

Nicole_B ✭✭
edited 12/09/19 in Smartsheet Basics

I'm having trouble getting my sheet to roll due dates for projects up to parent rows without excluding projects that have already been completed. I've tried enabling dependencies and using a min formula that looks at children rows, but neither options worked. I have no need to track start dates on this particular sheet, only end dates. Ideally I would want the parent row to display the nearest date listed in the children rows without including items that are 100% complete (I'm currently using a % Complete row to track this). Any thoughts?