Need Help with JOIN(COLLECT with HAS

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)))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!