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)?