Google-sheets – insert an hyperlink into a non empty cell of a Google Spreadsheets documents

google sheets

my problem is that if I add something like this in an empty cell of a Google Spreadsheets documents it work great

=HYPERLINK("www.google.co.uk"; "Google")

But If I add this link to a non empty cell it don't work.

For example if the content of my cell is something like to:

Linkt to interesting post: =HYPERLINK("www.google.co.uk"; "Google")

I can't see the hyperlink. Why? Can I do this thing in some way?

Tnx

Andrea

Best Answer

In order to combine text and formulas, the text must be wrapped in quotes, and concatenated to the link:

="Link to interesting post: " & HYPERLINK("http://www.google.com"; "Google")

Related Solutions

Google Sheets – How to Add Two Variables to a Hyperlink

= hyperlink( "https://www.google.com/search?q=" & B1 & "&var2=" & C1 )

This works for me.

Google-sheets – How to select a cell from all spreadsheets

Assuming you meant 'selecting from a certain cell from all sheets' (in one spreadsheet), custom function written in GAS that does that could look like this:

function avgCellAllSheets(cell) {
var arr = [];
SpreadsheetApp.getActive()
    .getSheets()
    .forEach(function (s) {
        arr.push(s.getRange(cell)
            .getValue());
    });
return arr.reduce(function (cur, prev, i) {
    return cur + (prev - cur) / (i + 1);
},0);
}

Fomula to be entered in the sheet is

=avgCellAllSheets(cell)

example:

=avgCellAllSheets("A1")

However, as custom functions like that seem to suffer from memoization, it will probably not auto-update after adding a sheet. There are workarounds, e.g. adding a dummy parameter, let's say the content of a certain cell that when incremented 'forces' a recalculation of the formula)

Best Answer

Related Solutions

Google Sheets – How to Add Two Variables to a Hyperlink

Google-sheets – How to select a cell from all spreadsheets

Related Topic