Using TEXTJOIN to return multiple values to a cell. Want to add hyperlinks.

[Paul_K]

I have a formula to take multiple cells in a table column and display them in a single cell.

=TEXTJOIN(CHAR(10),TRUE,IF((RequestExtract[Severity]=$B2)*(RequestExtract[P]=F$7)*(RequestExtract[Resolution]={"New","Validated","In progress","Test failed"}), RequestExtract[ID], ""))

The code above joins all the values from RequestExtract[ID] that match the criteria and then puts them in a single cell (with each value on a new line as shown below.

The number returned forms part of a URL (www.example.com/RequestExtract[ID]) and I would like to add hyperlinks to the matrix above, allowing the user to click on a number and go to the correct web page.
I have tried using HYPERLINK, but I'm not sure where to put it in the code so each number returned is a unique hyperlink.

=HYPERLINK("https;//www.example.com/"&TEXTJOIN(CHAR(10),TRUE,IF((RequestExtract[Severity]=$B2)*(RequestExtract[P]=F$7)*(RequestExtract[Resolution]={"New","Validated","In progress","Test failed"}), RequestExtract[ID], "")), TEXTJOIN(CHAR(10),TRUE,IF((RequestExtract[Severity]=$B2)*(RequestExtract[P]=F$7)*(RequestExtract[Resolution]={"New","Validated","In progress","Test failed"}), RequestExtract[ID], "")))

Doesn't work, it returns a single hyperlink and concatinates all the RequestExtract[ID] to the end of the URL


Any help gratefully received, I'm new to using TEXTJOIN and not sure how to combine other functions.

 

[Fluff]

As far as I'm aware you can only have a single hyperlink in a cell.