Forum Discussion
TEXTJOIN
I am trying to create a Risk Map using the TEXTJOIN function. I would be extracting data from a Risks tab to automatically updating the Risk Map. The formula I found was ="•"&TEXTJOIN(CHAR(10)&"•",TR...
PeterBartholomew1 Yes. They are supposed to be references to columns within a table. I tried removing the "!" and tried "•"&TEXTJOIN(CHAR(10)&"•",TRUE,IF(risks[likelihood]=$C3,IF(risks[impact]=D$8,risks![Title],""),"")). to no avail.
looks like you are getting close.
= "•"&TEXTJOIN(CHAR(10)&"•",TRUE,
IF((risks[Likelihood]=$E15)*(risks[Impact]=F$14), risks[Title],"") )
Because I use Office 365 my formula is slightly different
= "• " & TEXTJOIN(CHAR(10) & "• ", TRUE,
IF((risks[Likelihood]=@LikelihoodLevel)*(risks[Impact]=@ImpactLevel), risks[Title],"") )
To propagate the formula across columns select the range and use Ctrl+Enter rather than fill right.