Validation based on field contents of another field
Trying to write a validation calculation for the following criteria.
If field X = Option A (from a dropdown box), then field Y cannot be empty. Anything other than Option A in field X would allow field Y to be empty.
Can I do this with the built in validation options and a calculation or do I need to write a script and have it run as a script trigger on modify or save?