When bulk updating old Opportunities to 'Closed Lost' via Data Loader, some records failed to update with following error -

Required fields are missing: [Custom_PickListField__c]

How can i bypass this error, and update the Opportunity records to 'Closed Lost' ?

Note: These Open Opportunities have a close date way back in the past. Seems like these were created before the Custom_PickListField__c was made required.

1 Answer 1


You have to alter the validation rule so that it passes, or provide values to match the conditions. Altering the formula rule might be done by adding a rule for the CreatedDate (e.g. CreatedDate < DATE(2019, 1, 31) ). For "Required" fields set at the database level, you need to either provide a value, or remove the Required flag from the field's properties.

  • There is no validation rule on Opportunity. Jul 13, 2020 at 20:33
  • 1
    @user4947 Oh, so you have a globally required field? You'll need to provide a value for each record, or turn off the required flag.
    – sfdcfox
    Jul 13, 2020 at 20:35
  • If i turn off the the required flag temporarily, to be able to chnage the status to 'Closed Lost', and then turn ON the Required flag, would there be any repercussions. ? Jul 13, 2020 at 21:06
  • 1
    @user4947 The only possible problem is that users would be able to save records without this required field during that time. You may want to make it required on the page layout, but optional at the database level. This will keep UI users from bypassing your intent while you make this update.
    – sfdcfox
    Jul 13, 2020 at 23:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.