Hi everyone!
Excel offers this ability so I'm wondering if there's a similar formula I can use to achieve this here?
I want the "Link" column to be populated with a URL but the ID at the end of the URL needs to be populated with the "Number" column.
Bonus points if you can show me how to hide the URL string behind the same name of the number column as well.