When the account 'Salesperson' is filled in, any new Deal created should have this Salesperson as the Deal Sheet salesperson by default.  Currently, this is the functionality for the 'Coordinator' field.  At this point, the user who creates the Deal will default as the Salesperson on the Deal.