Custom column that pastes value of other column into url

[jondurbridge]

Hi, I have 1 table with multiple columns. One column is a unique Ticket ID. I need to create a new column which will create a url for each record. the url needs to be of the format http://urladdress="ticket ID"&ticket="ticketID"

so if the ticket id happened to be 222 the url I would need would be

http://urladdress=222&ticket=222

hopefully that makes sense?

the URL will always be exactly the same, but obviously the ticket ID will change for each row.

Thank You in advance

[Ashish_Mathur · Accepted solution]

Hi,

Create this calculated column formula

="http://urladdress="&[ticket id]&"&ticket="&[ticket id]

Hope this helps.