automatically add a URL prefix to text entered into a cell


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 "" as the URL
  3. cell only displays "1234" (as a hyperlink)

Thank you!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!