I'd like to create a custom function called "valueAndNote that takes two
arguments as such: valueAndNote(cellValue, noteValue). The second
parameter the noteValue, would be assigned to the active cell's note.
Here's my code so far:
function valueAndCell(cellValue, noteValue) {
cell = SpreadsheetApp.getActiveRange()
cell.setNote(noteValue);
return cellValue;
}
The idea here is to insert a note into a cell who's value is in another
cell. However, when I use the above custom function in my spreadsheet I
get the following error:
*"error:* Circular dependency detected".
Any ideas on how to do this or if it's event possible?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
