Insert Hyperlink into Google Sheets

I have created a hyperlink that needs to be inserted into Google Sheets using String Manipulation. However the formula gets inserted with a leading single quote which does not exist in the String Manipulation output. When I manually remove the leading single quote my hyperlink works. My initial research and hypotheses is that Google Sheets thinks it is text and doesn’t recognize the formula. Does anybody have any ideas how to get my hyperlink to be recognized as such by Google Sheets?

Actually I solved my own issue. I stumbled across this topic and it did the job. Never would have considered this in 100 years!!! Set the WriteRaw variable to false.

4 Likes

Oh wow! Thanks for sharing this one :slight_smile:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.