Google Sheets can display hyperlinks in cells but sometimes you do not want to see the whole hyperlink in the cell. Why not display a nice icon instead? Let me explain how to do it.
The following formula insert a icon that is hyperlinked to an issue on GitLab. The cell A17
should contain the issue number on GitLab. If A17
is blank the icon will not be displayed.
=IF(ISBLANK(A17);;HYPERLINK(CONCAT("https://gitlab.com/gitlab-org/omnibus-gitlab/issues/";A17);IMAGE("https://cdnjs.cloudflare.com/ajax/libs/foundicons/3.0.0/svgs/fi-link.svg")))
I use the link icon from the foundicons library hosted on cdnjs.