Adding a hyperlink to a number that is used in a formula.

[AnnaRemyy]

Hi everyone,

I've searched high and low and cannot find anything about using a hyperlink on a number that is actively used in a formula.

For example: I have 3 invoices for these prices-$500, $200, $100

I have an excel sheet with these invoice numbers that add up the numbers using a sum formula. I know I have $800 in invoices.

Now, I ALSO want to include a hyperlink that links each number to the invoice so when I click on the number it brings me to a pdf copy of the invoice from google sheets. How can I do this? When I add a hyperlink it breaks the formula.

Also- if there is a solution, is it possible to use it on google sheets?

[Tony Valko]

Also- if there is a solution, is it possible to use it on google sheets?

Just curious...

We see lots of questions wrt Google spreadsheets in this forum.

Doesn't Google provide a help forum for its own products?

[AnnaRemyy]

Maybe, but I'm primarily using excel (which is my preference.) My company wants the same document on google sheets, which I'll worry about later, I was just wondering if anyone happened to know whether or not the solution would work on google sheets as well. My focus however, is the excel solution.