function onEdit(e) {
var sheet = e.range.getSheet();
var row = e.range.getRow();
var symbols = ["X", "J", "N"];
var qtyMax = 5;
var rowValues = sheet.getRange(row, 1, 1, sheet.getLastColumn()).getValues()[0];
var symbolCount = {};
for (var i = 0; i < rowValues.length; i++) {
var cellValue = rowValues[i].toString();
if (symbols.includes(cellValue)) {
if (!symbolCount[cellValue]) {
symbolCount[cellValue] = 1;
} else {
symbolCount[cellValue]++;
}
if (symbolCount[cellValue] > qtyMax) {
Browser.msgBox("Le nombre de symboles '" + cellValue + "' dépasse la quantité maximale autorisée (" + qtyMax + ") dans la ligne " + row + ".");
sheet.getRange(row, i + 1).clearContent();
}
}
}
}