Subitems and column in Item

Our subitems are various physical events where some are called “Teamtjek 1”, Teamtjek 2" or "workshop). For each of these theres a date column. Do anyone here know if it’s possible to always get the next (upcoming) of those where the name contains “Teamtjek” as well as filter out those with a specific status (“unplanned”)?