Hi!
I’ve been thinking about this question for a while but now that there’s a use case with it, I thought I should ask.
I have a table with page names in column A. Those page names are names of actual pages in the current document. I want to be able to create a column B that automatically creates a URL from column A. When clicked, that URL will redirect the user to the page in question.
I see that each page has a unique ID but if I have to hardcode an ID for each of the names, I might as well just input the page URL instead of having a formula column. I haven’t seen a way to make this happen, does anyone have a thought on how to do this?