I am having issues developing a validation against a people or group column.
I have a "Status" field that is a Radio button choice field.
A request has been made that if my People or Group field "Employee" contains a value the Status field must be set to "In Progress" or "Completed" otherwise display an error on the entry screen. (I am trying to add the column validation in the "Status" field which allows validations, the People or Group column does not have a place on the screen to implement the validation.)
I have no issues developing a validation formula against the Status field, however when I try to implement the People or Group "Employee" column into the formula I get errors.
Possible Solutions I Tried
When I try to develop the formula as a list validation the Employee column does not even display.
I tried to create a calculated text column and try loading the "Employee" values into so I could validate off of this column but it appears as though I can't do this either.
Is there any ideas how to create a validation setting against the Employee (people or group) column or is my only option to implement this validation into an event receiver?
Any input is greatly appreciated.