How to add linked issues to bulk change

[Anna Konieczna]

Hi all,

I would like to ask if it's possible to add field "linked issues" to bulk change? 

Regards,

Anna

[RianS]

Looks like this can be done pretty easily. You can look at this link for more information. It basically involves using the HYPERLINK() function and you structure it like this:

=HYPERLINK("https://www.google.com/search?q="&A1&"&oq="&A1")

This will turn into the following assuming cell A1 has the value "Search Term",

https://www.google.com/search?q=Search Term&oq=Search Term

You can put a function around the cell such as SUBSTITUTE(A1, " ", "%22") to replace any spaces in the cell value with the url friendly character.

[Cyril Maurer]

Thank you very much.

I was really close but I the "& was missing.