Need Help with JOIN(COLLECT with HAS

Patrick D

I can get it display the Status in the Predecessor Status column when there is a single Predecessor, but not display multiple Status values when there are multiple Predecessors.

=IF(Predecessors@row <> "", JOIN(COLLECT(Status:Status, RowID:RowID, HAS(Predecessors@row, @cell)), CHAR(10)))

Paul Newcome

You will need a helper column that is a multi-select dropdown and converts each of the predecessors into a different "selection". Then you would be able to use the HAS function.