Hey guys/gals,
Im looking to restrict users from continuing to fill our forms without having selected from a drop down first.
Example:
If user enters a value in I10 they must select a unit of measurement in J10. I have set data validation on the rest of the form using this formula:
I also selected "Custom" and "Ignore blank". Problem is, even if I change J10 to anything else the error still pops up. I need it give me an error ONLY IF J10 contains "(UOM)" or if its blank.Please Login or Register to view this content.
Help please!
Bookmarks