I am trying to create a simple workflow that would make it so that the 'Close Date' in an Opportunity is automatically updated to anything (even if NULL) that is in the Custom Date Field called 'Target Campaign End Date'.
Nothing is working so far so here is my main question - is there any way to submit a new Opportunity with this required field being empty, but being populated due to a workflow when 'Save' is clicked?