I need to update a custom picklist field, "Program",  on the Lead object when a Lead is added to a campaign.  I created a workflow on Lead, with criteria: Evaluate the rule when a record is created, and any time it’s edited to subsequently meet criteria.  The rule criteria is:
Campaign.Name  = 'Soccer' &&
ISPICKVAL(Campaign.Status, 'Joined')
I activated the rule, but it is not firing. 
I have tried different rule criteria, such as CampaignId='701U0000000xMD3', and have tried using Campaign Member as the rule object, but that won't work because I need to update field on Lead.

Does this require an Apex trigger to work?  I am not a coder...

Thanks for any help!
Meli