What formula to use to check if an item is a subitem of a subitem?

[Jannis]

Hi @Freerk_Lap,

thanks for sharing your doc.

I looked into it, but unfortunately couldn’t find a condition to filter the selection consistently.

I would suggest changing something in the structure of the document so that you have a clean hierarchy.
If you have a clean hierarchy in your table, filtering is much easier.

Please take a look at this topic, which helped me a lot in building a task hierarchy:

Sort by Version

Hi Community, Imagine a Table with a column called “order” with rows like: 1 1.1 1.1.1 1.2.1 2.1.1.1.1 … depending on the context, some rows might have more dots than others. Does any one know a clever way to sort it without building tons of helper columns? Thanks in advance.

---

Sincerely
Jannis