Note that I’ve replaced all empty cells with a dash. Var lcol = 9 // number of column where validation starts A = 1, B = 2, etc. Var NumOfLevels = 7 // number of levels of data validation Var LogSheet = 'Data2' // name of sheet with data SmartDataValidation ( event, TargetSheet, LogSheet, NumOfLevels, lcol, lrow, offsets ) ^ means offset column #4 on one position right. Var lrow = 2 // number of row where validation starts Var lcol = 2 // number of column where validation starts A = 1, B = 2, etc. Var NumOfLevels = 4 // number of levels of data validation Var LogSheet = 'Data1' // name of sheet with data Var TargetSheet = 'Main' // name of sheet with data validation OR copy the script to your current file.The installation of the Dynamic script is simple: 2+ sheets with 1 data source Both sheets have a sheet “Data” as a source sheet. Auto-complete If a user selects the item with the only value to choose from, automatically the next value will appear. First is Transport +colour, the second is size + model. 2+ rules in 1 sheet This sample shows 2 dependent drop-downs on a single sheet. In a sample above, the column “Code” is skipped. Multilevel select Select mainland in level 2, then country in level 3 The list of cities will appear in level 4 Reorder columns Make 2+ level dependent drop-down lists in Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |