I've searched for this, can't find anything, but I'm pretty sure it existed at some point (but I might be crazy).
We have dates in a subitem column. I want to show (on the parent) the NEXT date in that column but ONLY if the subitem status is NOT "Task Complete".
In other words, I only want to see the next date if the "thing" isn't already complete. I feel like I've seen this before, but can't find it.