Apologies if the title (or this description) isn’t clear!
Here’s an example of what I’m trying to do:
I have one column where every cell contains an ID number (eg. 837264). I would like to be able to click that number, and have it take me to the appropriate URL, where the URL is always of the from https://website.com/ID number. So in this example, clicking on the cell would take me to https://website.com/837264.
Is there a way to do this? I’m having trouble figuring out how to write a formula such that the URL base is the same across one column, and the unique cell value defines the end of the URL.