TextJoin in Appsheet

[Jpaulsen]

Just wondering what the work around is for this excel formula

 "" =TEXTJOIN(", ",TRUE,UNIQUE(IF(Z2=$C$2:$W$75,$B$2:$B$75,""))) ""

Z2 = Value to look for

$C$2:$W$75 = Size of area to look in 

$B$2:$B$75 = Values that is associated to the look up value 

Work great in Excel, I can do wide searches with it, but AppSheet doesn't like the formula when it's in worksheet. 

Thank you in advance.