*** Im new to this forum, if my question is not in the correct location please let me know. thanks***
I have a question related to validation rules inside the forms:
I have a spreadsheets with the following columns (in that order):
Name, Data, Section, Route, Comment.
I added a list validation rule to the Region and Route columns (Route - 1,2,3,4,5 etc. Route - 1A, 2A, 3A, etc.)
When I enter data in the form and (purposely) enter the wrong data in the Route columns for example, I get the custom validation rule message telling me I entered the wrong, I click 'Retry', enter the correct data and press 'Enter.
A new entry is added to the table with the information I entered, but any data I entered before the 'Route' column is blank (in this case, the name and data columns). The rest of the columns are populated.
It appears that if a validation rule is triggered its resets the columns prior to the cell where the validation rule is set.
Do you know what am I doing wrong and how to solve it? Thank you.
Bookmarks