I'm trying to include Validation Settings for my List Form where I've got a column called
Food Service and another column called
Food Service Type, where
Food Service is a "Yes/No" type column and
Food Service Type is a "Choice Menu" where I've got one of the menu options as "Please Select an Option". I'm trying to validate to see if the user has "Yes" chosen for
Food Service, that it should be checked if "Please Select an Option" is selected, and if it is, kick-back a message saying that they should select an option. My formula appears as follows:
=IF([Food Service]="Yes",IF([Food Service Type]="Please Select an Option", FALSE),TRUE)
I've tried a multitude of other different ways as a sort of sanity check, but unsuccessfully. I'm pretty sure the way it's working now, it sees that combination above as false, but then moves on to the Does anyone have suggestions on how to make this work (if not through list validation, another method)?