From a table extract rows with a condition but that other data from the table is not repeated

From a task table, I try to extract the rows of clients that do have finished tasks but do not have new tasks started. It is about not leaving customers abandoned by mistake.
It seems simple, but it does not come out
How could it be done

It is very hard to help you without more detail, but here is a generic expression you might start from:

  ISNOTBLANK( FILTER( Tasks , #are-finished-condition# ) ) ,
  ISBLANK( FILTER( Tasks , #are-started-condition# ) )

You’ll probably want to use this in a Slice.

1 Like