Sheet1
Sheet1
Sheet2
Sheet2
My code enter image description here
In the subcategory it cannot get data by category
// sheet1.getCell(‘B’ + (+index + 3)).dataValidation = {
type: ‘list’,
allowBlank: true,
formulae: [INDIRECT(${sheet2.name}!$A$${index + 3})],
};