Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a column of cells in a Google Spreadsheet with values such as:


What I would like to do is convert all these into a hyperlink and keep the value as the link text:


...where {value} is the value of the cell. I know the format of a hyperlink in a Google spreadsheet but I don't want to do this manually every time I put in a number. I want a simple process that when I add a new row the contents of this column is turned into a link with the value I input.

I tried this:


But I get:

error: Circular dependency detected

share|improve this question
up vote 4 down vote accepted

I wasn't able to reproduce your results. As a matter of fact, it worked perfectly.

enter image description here

What you tried to do is most probably the following:

In A1 you typed in =HYPERLINK(CONCATENATE("http://www.example.com/id/",A1);A1) and this yields an error of coarse.


If you really want to get the result in A1, then you need to use a script.


// global
var ss = SpreadsheetApp.getActiveSpreadsheet();

function onOpen() {
  var menu = [{name: "create URL", functionName: "createURL"}];
  ss.addMenu("URL", menu);

function onEdit(e) {
  var activeRange = e.source.getActiveRange();

  if(activeRange.getColumn() == 1) { 
    if(e.value != "") { 

function createURL() {
  var aCell = ss.getActiveCell(), value = aCell.getValue();


The e.value will retrieve the cells value (only applicable a cell). The setValue() will add the concatenated string into the getActiveRange(). All is only executed when e.value contains something and the active range is in column A.

I've created an extra menu option as well, to be able access the script this way.


I've created an example file for you: onEdit URL builder
Add this script via Tools>Script editor, into the script editor. Press the "bug" button and you can use the script.

share|improve this answer
Your right I did type it in A1. I want the link to appear in the same cell. So in my A column every time I type a number it will turn that into a link with the number appended to the url. Does that make sense? – Kirill Fuchs Oct 12 '13 at 17:39
@KirillFuchs I've added a script solution, that will yield the URL when entering a value in A1. – Jacob Jan Tuinstra Oct 12 '13 at 19:05
Thank you, I was messing around with a script and mine was turning out to be some weird mess. This is a-lot simpler. PS: updated your script to output the HYPERLINK function :). Thank you again. – Kirill Fuchs Oct 12 '13 at 19:31
@KirillFuchs See revised answer and example file. Good luck !! – Jacob Jan Tuinstra Oct 12 '13 at 19:59
Thank you once again! – Kirill Fuchs Oct 12 '13 at 20:01

I found a way around it and no script needed. You just need to use another sheet.

See the updated sheet mentioned above for the working example.


Hope this helps.

share|improve this answer
Isn't this what the OP tried in the question? – Vidar S. Ramdal Jan 15 '15 at 8:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.