Our school is moving to G Suite. I want to create/modify a script in one of my google sheets which will add a once-off validation rule to a column in one of my sheets.
For each cell in column C (starting with C2), return a range from the same row but using columns I2:AA2 as the dropdown list, then move on to the next row. the row number will be the same across the columns as you go down (C3 = I3:AA3, C4 = I4:AA4, etc down to 1000 (end of the sheet for now))
i have always been terrible at the loop codes, and google scripts are brand new to me, so was hoping someone could point me in the right direction.
i have found the google documentation regarding data validation scripts
, just not sure how to customise it for my own sheet.
Most of the tutorials and scripts I've been able to find have been to run a datavalidation script onEdit of a cell, but i find they are very slow for me.
Any help appreciated.
p.s. for those of you who have been wondering where i disappeared to, i have switched careers to teaching in a secondary school (science, physics, information and software technologies)!! it was supposed to improve my work-life balance but it is the hardest, most demanding, most time-sucking job that I have ever come across in my life!! So, many (all??) of my hobbies are on the backburner for the moment. I am enjoying the challenge, though, and the cliché that it is rewarding is true. I've been told things will settle down for me after about 3(!!!!) years. Currently doing an appalling job at not burning-out.