I would like to create an empty checkbox in the Column A, when the Column C of the same row is changed.
It's pretty easy to do it when I modify "manually" the column C :
function onEdit(e) {
if (e.range.getColumn() == 3) {
var row = e.range.getRow();
SpreadsheetApp.getActiveSheet().getRange(row, 1).insertCheckboxes();
}
}
The problem is that my data in the Column C are imported through an IMPORTRANGE, which does not trigger my script.
Do you know how to solve my issue ?
I've tried to change onEdit by onChange but it still doesn't work.
I've also tried to import my data in an other Sheet and to then to "forward" it with a "dirty" "=sheet1!C1" for the row1 for exemple, but it still does not work.
