When using dependent drop downs, my Valid_IF expression is correct, but I am getting this error
Column Name ‘Applications’ in Schema ‘Lubricant Selection_Schema’ of Column Type ‘Enum’ has an invalid data validation constraint ‘=IF([Applications] = “Hydraulic”, “[hyd. types]”, “[applications]”)’.
I am trying to say:
If Hydraulic is selected
I need the options: “Vane Pump” or “Gear Pump”
If Gearbox is selected
I need the options: “Standard” or “Worm Gear”
If Worm Gear is selected
I need the options: “Centrifugal” or “Globoid”
I have all of this listed in Google Sheets, and I am writing my Valid_IF as IF([Applications] = “Hydraulic”, “[hyd. types]”, “[applications]”)
This is because my columns in google sheets are “Applications”, Hydraulic" and “Hydraulic Types”.
If under the application drop down, hydraulic is chosen, I wanted another drop down to display the two different types of hydraulics.
LinkedIn
Twitter
