function search(searchtext){
var spreadsheetId = '1SyTCaoqzM3X7QAgpyFCVOQ7npfqWjVO15zymZsEX7ig'; //** CHANGE !!!
var dataRage = ['2023','2024']; //** CHANGE !!!
var data = Sheets.Spreadsheets.Values.get(spreadsheetId, dataRage).values;
var ar = [];
data.forEach(function(f) {
if (~f.indexOf(searchtext)) {
ar.push(f);
}
});
return ar;
}
alguien que me ayude