title: How to pass the row and column instead of the value in a custom Google Sheets function?
body: <pre><code>function calculateIntervall(note) {//The passing argument gives me the value of the cell with the note, NOT the column or row of particularly this cell
    var spreadsheet = SpreadsheetApp.getActive();
    var col = spreadsheet.getActiveCell().getColumn();//get the column of note anyhow?
    var row = spreadsheet.getActiveCell().getRow();//get the row of note anyhow?
    note = spreadsheet.getCurrentCell().offset(row, col).activate().getNote();//get the value of the note
    return col + row;
  };
  </code></pre>
  
  <p>This is just an example program, that explains my question the best. The current program returns the sum of the row and the column of the active cell (the cell with the function). But I need the sum of the parameters of the cell with the note.</p>
  
  <p>I just want to have the row and the column kinda like this (using the standard functions):</p>
  
  <pre><code>=ROW(note)
  =COLUMN(note)
  </code></pre>
  
  <p>The functions usually look like this:</p>
  
  <pre><code>=ROW(A5) -&gt; this returns 5
  =COLUMN(C2) -&gt; this returns 3
  </code></pre>