automatically add a URL prefix to text entered into a cell

colepstewart

Hello!

I have a sheet where my team members enter a ticket number into a column and then we hyperlink those ticket numbers to an external URL. In every case, the URL associated with a ticket number is the same, with exception to the final characters which are always the unquire corresponding ticket number. Is there a way to always add the first string of the URL to this cell, and add the specific ticket number to the end?

For example:

1. User enters "1234" in the cell
2. cell populates hyperlink with "www.acmetickets.com/ticket/1234" as the URL
3. cell only displays "1234" (as a hyperlink)

Thank you!

--Cole

Paul Newcome

You would need to use a third party app such as Zapier, the premium add-on Bridge, or the API to get it to work exactly like that.

If you are ok with the link being in another column, you can use this formula:

="www.acmetickets.com/ticket/" + [Ticket Number Column Name]@row

Paul Newcome

You would need to use a third party app such as Zapier, the premium add-on Bridge, or the API to get it to work exactly like that.

If you are ok with the link being in another column, you can use this formula:

="www.acmetickets.com/ticket/" + [Ticket Number Column Name]@row