Accessing a URL within a GSheet Cell which has been referenced by IMPORTRANGE and FILTER

Asked Jul 11 '19 at 09:54

Active Jul 11 '19 at 13:46

Viewed 76 times

Source sheet contains a cell which looks like this -- =HYPERLINK("https://drive.google.com/drive/u/0/folders/somegdrivesheet","Completed") I then have a complex formula which references that cell and then delivers it to another sheet. At this point i can click on the output of the formula and still see its a URL - click the cell - link becomes available and i can navigate to it.

I cant workout how to extract the URL from this cell so i can use it in the referencing sheet programatically.

Tried various things:-

ISURL is false for the cell with the value
ISFORMULA is false for the cell with the value
So i cannot address the formula directly

Created custom function where i pass in the cell address and attempt to grab the values from the cell. All i can get is the text value associated with the cell and not the URL.

cellValue = cell.getValue(); -- Just text value not URL
cellValue = cell.getValues(); -- NOTHING
cellValue = JSON.stringify(cell); -- NOTHING
cellValue = cell.getRichTextValue(); -- NOTHING

Any guidance appreciated.

Example GSheet here

edited Jul 11 '19 at 10:28

asked Jul 11 '19 at 09:54

Simon Taylor

2

Possible duplicate of [Apps Script: How to get Hyperlink from a cell where there is no formula Hyperlink](https://stackoverflow.com/questions/53863752/apps-script-how-to-get-hyperlink-from-a-cell-where-there-is-no-formula-hyperlin) – TheMaster Jul 11 '19 at 10:27
That is the solution - thanks! – Simon Taylor Jul 11 '19 at 10:45
You can accept the question as a duplicate. – TheMaster Jul 11 '19 at 17:58

Accessing a URL within a GSheet Cell which has been referenced by IMPORTRANGE and FILTER

0 Answers0