I have one scenario.
I need to do while downloading a empty template.
I have done code by data validation.
Each column will have different character length.
Lets take i have to do validation for 3 columns (Column 8 - length 10, Column 9 - length 15, Column 10 - length 30)
When i apply Validation.Formula, it takes length of 30 to all the three columns.
Please advise me on above point to do data validation.