Is there a way to do this?

Thanks!

Can you elaborate?

I should have said validate by a value list OR a calc, because value list AND a calc is there already.

I need to validate by a value list and have some exceptions that are not part of the value list but will let the validation pass.

You have to validate by calculation alone. In your calculation, check if the entry is a member of the value list OR is an exception.

Thanks comment.

I don't see a way in a calc to validate if a field's data is part of a value list, could you point me in the right direction?

Try:

not IsEmpty (

FilterValues ( ValueListItems ( Get (FileName) ; "yourValueList" ) ; ValidatedField )

)

Thanks Commnet!

Works like a charm, I have the field validating off of 2 value lists!

not IsEmpty ( FilterValues ( ValueListItems ( Get (FileName) ; "ValueList 1" ) ; CAO Number ) ) or not IsEmpty ( FilterValues ( ValueListItems ( Get (FileName) ; "ValueList 2" ) ; CAO Number ) )