Filter by subitems status columns

Hello guys,

In a board I have items with subitems. These subitems have got few status columns. Is there a way to filter the board based on the status column of the subitems ?

For exemple:

I want to filter my board to display only subitems where column 3 = ‘Working on it’


It is not currently possible to filter subitems.

In the meantime, this trick might work for you. It will allow you to filter the main items that have subitems where that column is “Working on it”:

  1. Create a formula column in the subitems “SIx”: SWITCH({Status}, “Working on it”, 5, 0)
  2. Mirror that column in the main board “X” returning Max.
  3. Filter on “X” = 5.