Making hooks clickable in Google Sheets

Discussion & Help
1

When I paste a Link or a Markdown Link into Google Sheets, it isn’t clickable. Can someone help me either:

  1. make it a live, clickable link, or
  2. describe what kind of link I could paste that would make this work?

Trying to invoke “=HYPERLINK()” doesn’t work either. I know there must be an easy solution to this, I just can’t find it.

Thank you!

2

If I’m understanding, this problem is solved with the new Universal Link feature (Google blocks non-web links for security reasons)

1 Like
3

Thanks, @stevelw.

Welcome to the Hookmark Forum , @Seth. Copy As Universal Link and Copy as Universal Markdown Link are available if you click on Action ☰ button menu in title bar and hold down option key. The links only work in Safari. Apple introduced universal links, but other browsers have not yet adopted it.

The feature is described in Hookmark 5 Release Notes and Download Link – Hookmark . Making hooks clickable in Google Sheets - Discussion & Help - Hookmark Forum. We’ll publish a separate help page on this soon.

4

Thank you all so much for your responses. I do have Pro, but I must have missed the release notes.

One more thing! When I am in apple mail, option-command-c does not work. I would like to use the shortcut, but when I select it and try the shortcut, it gives me the little ‘blip’ error sound. I’ve looked all over for any conflicting shortcuts, and I can’t find them.

Thanks!

5

that’s strange. I tested again and it works for me. I wonder if some piece of software is intercepting the keyboard shortcut in Mail.app. Or perhaps you’ve configured that keyboard shortcut in Mail.app itself to do something else. That gets configured in System Preferences.

6

MacOS, Chrome, Google Sheets.
I use Tinyurl.com
First I use Alfred for Mac.
Then I downloaded the workflow.

Whenever I want to use a link to a file or folder on my Mac,

  1. I copy the hookmark link to the file or the folder
  2. I then use the Alfred box to type in “tiny”, then hit Enter
  3. then paste the hookmark link
  4. the “tiny url link” is automatically copied into my clipboard
  5. then I select the Google Sheets Cell, [Insert Link]
  6. Command-V to paste the tiny url.
    Works for me every single time

The only extra step in invoking the Alfred box, typing tiny, ENTER, then Command-V to paste.