Image in a cell with a hyperlinkCount non-blank cells based on arrayformula in Google SpreadsheetsAdd two variables to a HyperlinkHow to get a cell to show blank if it cannot lookup the search key?Drop part of a cell value after a specific characterCount cells with or without image in Google SheetsVLOOKUP using cell reference with IMPORTRANGE gives errorIssue with IMAGE() functionGoogle Sheets - Extract URL From a Cell Containing a HyperlinkIgnore formula if cell is blankIMAGE from Google Drive in Google Sheets
If I cast Expeditious Retreat, can I Dash as a bonus action on the same turn?
Is a tag line useful on a cover?
How does one intimidate enemies without having the capacity for violence?
Email Account under attack (really) - anything I can do?
How can bays and straits be determined in a procedurally generated map?
Why are electrically insulating heatsinks so rare? Is it just cost?
"to be prejudice towards/against someone" vs "to be prejudiced against/towards someone"
Can an x86 CPU running in real mode be considered to be basically an 8086 CPU?
Do VLANs within a subnet need to have their own subnet for router on a stick?
Why doesn't H₄O²⁺ exist?
Is it important to consider tone, melody, and musical form while writing a song?
LaTeX closing $ signs makes cursor jump
Which models of the Boeing 737 are still in production?
Why do falling prices hurt debtors?
How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?
strToHex ( string to its hex representation as string)
What defenses are there against being summoned by the Gate spell?
Font hinting is lost in Chrome-like browsers (for some languages )
How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?
Can divisibility rules for digits be generalized to sum of digits
Theorems that impeded progress
"You are your self first supporter", a more proper way to say it
can i play a electric guitar through a bass amp?
Arthur Somervell: 1000 Exercises - Meaning of this notation
Image in a cell with a hyperlink
Count non-blank cells based on arrayformula in Google SpreadsheetsAdd two variables to a HyperlinkHow to get a cell to show blank if it cannot lookup the search key?Drop part of a cell value after a specific characterCount cells with or without image in Google SheetsVLOOKUP using cell reference with IMPORTRANGE gives errorIssue with IMAGE() functionGoogle Sheets - Extract URL From a Cell Containing a HyperlinkIgnore formula if cell is blankIMAGE from Google Drive in Google Sheets
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I need a cell that contains an image to also contain a hyperlink.
Following formula is the only one I found but doesn't work (error analyzing formula)
=HYPERLINK("URL", image("URL"))
Following formula I tried shows a blank cell but the link works
=hyperlink("URL"; Image("URL"))
google-sheets formulas links images
edited 2 days ago
user0
10.5k71636
asked 2 days ago
Marek MarhoulMarek Marhoul
478
add a comment |
I need a cell that contains an image to also contain a hyperlink.
Following formula is the only one I found but doesn't work (error analyzing formula)
=HYPERLINK("URL", image("URL"))
Following formula I tried shows a blank cell but the link works
=hyperlink("URL"; Image("URL"))
google-sheets formulas links images
edited 2 days ago
user0
10.5k71636
asked 2 days ago
Marek MarhoulMarek Marhoul
478
add a comment |
I need a cell that contains an image to also contain a hyperlink.
Following formula is the only one I found but doesn't work (error analyzing formula)
=HYPERLINK("URL", image("URL"))
Following formula I tried shows a blank cell but the link works
=hyperlink("URL"; Image("URL"))
google-sheets formulas links images
edited 2 days ago
user0
10.5k71636
asked 2 days ago
Marek MarhoulMarek Marhoul
478
I need a cell that contains an image to also contain a hyperlink.
Following formula is the only one I found but doesn't work (error analyzing formula)
=HYPERLINK("URL", image("URL"))
Following formula I tried shows a blank cell but the link works
=hyperlink("URL"; Image("URL"))
google-sheets formulas links images
google-sheets formulas links images
edited 2 days ago
user0
10.5k71636
asked 2 days ago
Marek MarhoulMarek Marhoul
478
edited 2 days ago
user0
10.5k71636
asked 2 days ago
Marek MarhoulMarek Marhoul
478
edited 2 days ago
user0
10.5k71636
edited 2 days ago
user0
10.5k71636
edited 2 days ago
user0
10.5k71636
10.5k71636
asked 2 days ago
Marek MarhoulMarek Marhoul
478
asked 2 days ago
Marek MarhoulMarek Marhoul
478
asked 2 days ago
Marek MarhoulMarek Marhoul
478
478
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
=HYPERLINK("https://mail.google.com/mail/u/0/";
IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3))
demo spreadsheet
answered 2 days ago
user0user0
10.5k71636
I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you
– Marek Marhoul
2 days ago
add a comment |
Your first formula worked for me. Perhaps there's something off about the way you've formatted one of the URL's?
answered 2 days ago
Tran SituTran Situ
1212
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason?
– Marek Marhoul
2 days ago
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use
– Marek Marhoul
2 days ago
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "34"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f127136%2fimage-in-a-cell-with-a-hyperlink%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
=HYPERLINK("https://mail.google.com/mail/u/0/";
IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3))
demo spreadsheet
answered 2 days ago
user0user0
10.5k71636
I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you
– Marek Marhoul
2 days ago
add a comment |
=HYPERLINK("https://mail.google.com/mail/u/0/";
IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3))
demo spreadsheet
answered 2 days ago
user0user0
10.5k71636
I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you
– Marek Marhoul
2 days ago
add a comment |
=HYPERLINK("https://mail.google.com/mail/u/0/";
IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3))
demo spreadsheet
answered 2 days ago
user0user0
10.5k71636
=HYPERLINK("https://mail.google.com/mail/u/0/";
IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3))
demo spreadsheet
answered 2 days ago
user0user0
10.5k71636
answered 2 days ago
user0user0
10.5k71636
answered 2 days ago
user0user0
10.5k71636
answered 2 days ago
user0user0
10.5k71636
10.5k71636
I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you
– Marek Marhoul
2 days ago
add a comment |
I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you
– Marek Marhoul
2 days ago
I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you
– Marek Marhoul
2 days ago
I found out that the problem was only with the image link. It was from Google Drive and the share link wasn't usable for this. So as you commented, this formula works just fine. Thank you
– Marek Marhoul
2 days ago
add a comment |
Your first formula worked for me. Perhaps there's something off about the way you've formatted one of the URL's?
answered 2 days ago
Tran SituTran Situ
1212
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason?
– Marek Marhoul
2 days ago
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use
– Marek Marhoul
2 days ago
add a comment |
Your first formula worked for me. Perhaps there's something off about the way you've formatted one of the URL's?
answered 2 days ago
Tran SituTran Situ
1212
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason?
– Marek Marhoul
2 days ago
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use
– Marek Marhoul
2 days ago
add a comment |
Your first formula worked for me. Perhaps there's something off about the way you've formatted one of the URL's?
answered 2 days ago
Tran SituTran Situ
1212
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Your first formula worked for me. Perhaps there's something off about the way you've formatted one of the URL's?
answered 2 days ago
Tran SituTran Situ
1212
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
Tran SituTran Situ
1212
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
Tran SituTran Situ
1212
answered 2 days ago
Tran SituTran Situ
1212
1212
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Tran Situ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason?
– Marek Marhoul
2 days ago
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use
– Marek Marhoul
2 days ago
add a comment |
I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason?
– Marek Marhoul
2 days ago
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use
– Marek Marhoul
2 days ago
I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason?
– Marek Marhoul
2 days ago
I am from EU and from what I have seen there are some slight differences between EU and other syntaxes, maybe that might be the reason?
– Marek Marhoul
2 days ago
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use
– Marek Marhoul
2 days ago
yep, you are right. It was actually the difference between EU syntax and the rest of the world. We use a semicolon instead of a comma and it was the image link that wasn't working for this use
– Marek Marhoul
2 days ago
add a comment |
Thanks for contributing an answer to Web Applications Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f127136%2fimage-in-a-cell-with-a-hyperlink%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
