say my_urls contains a string that represents a valid URL.
say my_labels contains a string that I want to be displayed in the table
HYPERLINK(my_urls, my_labels) results in the table cell displaying “my_labels cell’s contents two-spaces my_urls cell’s contents”
if I change to HYPERLINK(my_urls, “some hardcoded string”) I get a valid, working clickable hyperlink.
Can anyone shed light on what’s going on here?
The Data source is a medium-sized GoogleSheet and I have created Calculated Fields based on that data.
Thanks
EDIT: Never mind. Starting a New Report and relinking the same spreadsheet as my data source ended up resolving this problem
EDIT2: But creating this formula brought the problem back:
if(my_urls !=””, hyperlink(my_urls, my_labels), my_labels)
In this case I am getting that weird label url concatenation I described. (What I want is for the column to display the label as plain text if there is no associated url, and display a hyperlink (underlined, clickable) if there is
EDIT3: I have noticed that when I created the calculated field with HYPERLINK() formula only, the Type of this field was automatically set to “Hyperlink” and it cannot be changed. However, with the other formula, the Type is set to “Text” by default. I can also change it to “URL”, but there is no option “Hyperlink”. I am suspecting that Hyperlink is only properly rendered (as my label text only, underlined) if and only if I always return a hyperlink from my calculated field’s formula and it is typed as a Hyperlink by Data Studio.