I am using Sharepoint 2010 Foundation. I have a list setup that multiple departments access and update as orders move through production. Orders get entered and assigned to a user (the salesperson) responsible for that particular project, then they can check on the status of their order from entry, purchasing, production, quality control, etc.
What I would like to do is when the shipping department modifies one field - let's say setting a value to "ready for pickup", the assigned salesperson is automatically sent an e-mail.
We use a hosted Sharepoint setup, so I am hoping that this can be accomplished with notifications (I believe not), but perhaps by using a Workflow, which I have a limited understanding of.
Your help would be greatly appreciated, Mark