N
N
N565442021-04-06 09:45:14
Google Sheets
N56544, 2021-04-06 09:45:14

How to get cell note in google spreadsheet?

Is there some built in function to get a note or how to add a new one?
Through the function CELL(data_type; reference) this cannot be done)
606c034bb3d9d616924679.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
Grigory Boev, 2021-04-06
@N56544

Like this:

/**
* Возвращает примечание к ячейке
* Telegram - @ProgrammerForever
*
* @param {string} sheetName Имя листа
* @param {string} rangeName Адрес ячейки в текстовом виде
* @return Возвращает примечание к ячейке
* @customfunction
*/
function getNotes(sheetName, rangeName){
  return SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName).getRange(rangeName).getNotes()
}

Use something like this:
=getNotes("Лист1";"A10")
=getNotes("Лист1";"A10:B15")

M
Mimocodil, 2021-04-06
@Ezekiel4

There is no such function. This is done through the script editor.
https://developers.google.com/apps-script/guides/sheets

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question