Exception: Enter Value for Field
From AgileApps Support Wiki
This error occurs when referencing a field that has a null value. Prevent the error by using the ISNULL function in an IF statement:
- IF( ISNULL(field), expression-to-use-when-field-is-null, expression-that-uses-the-field )