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.
Can you post what the error returns as? I see nothing wrong with your above formula technically, although I would say I recommend making your RISKS table reference columns static. Like this:
=TEXTJOIN(CHAR(10)&"•",TRUE,IF(RISKS[[LIKELIHOOD]:[LIKELIHOOD]]=$C3,IF(RISKS[[IMPACT]:[IMPACT]]=D$8,RISKS![[TITLE]:[TITLE]],""),""))
I have a near identical formula but instead of referencing risks I'm referencing start and end dates, and I'm pulling multiple columns into one text string for each matched date. Here's my exact formula:
=TEXTJOIN(CHAR(10),TRUE,IF(MyTable[[Start Date]:[Start Date]]<=C14,IF(MyTable[[End Date]:[End Date]]>=C14,MyTable[[Name]:[Name]]&" "&MyTable[[Job]:[Job)]],""),""))
=TEXTJOIN(CHAR(10)&"•",TRUE,IF(RISKS[[LIKELIHOOD]:[LIKELIHOOD]]=$C3,IF(RISKS[[IMPACT]:[IMPACT]]=D$8,RISKS![[TITLE]:[TITLE]],""),""))
I have a near identical formula but instead of referencing risks I'm referencing start and end dates, and I'm pulling multiple columns into one text string for each matched date. Here's my exact formula:
=TEXTJOIN(CHAR(10),TRUE,IF(MyTable[[Start Date]:[Start Date]]<=C14,IF(MyTable[[End Date]:[End Date]]>=C14,MyTable[[Name]:[Name]]&" "&MyTable[[Job]:[Job)]],""),""))