Auto populating a field in a sharepoint list

How do I auto populate a field on one list based on an item entry in another? I have two lists, lets just call the first list DepartmentList and the second list TaskList (both are just custom lists).

DepartmentList will be the list used to pull data from and it contains: Title, Assigned To, Team (Column type for Title and Team is Single line of text, Assigned To is People or Group)

An example value to be entered into this list - IT Support , John Smith, IT

TaskList contains: Task Name, Start Date, End Date, Due Date, Assigned To, Team (Column Type for Title and Team is Single line of text, Assigned To is People or Group, and the others are just Date and Time)

All I need is a simple out of the box solution (if any) to auto populate the Team column when a person is selected for the Assigned To field. Example, If I was to enter John Smith for the Assigned To field, the Team column within TaskList will auto populate with the value of IT.

Also, we'll need to ensure that if the value within the Team column has changed, the values within TaskList is also updated with those changes.

We're using WSS 3.0 if that makes any difference.

Thank you in advance.
vithal_mAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GreatGermConnect With a Mentor Commented:
There's no true oob solution for this.  You can use a workflow to handle this for you and have it do a lookup on DepartmentList based on what is selected during the entry then copy the corresponding value to the Team column of the new item. You can set workflows to fire on create and/or on change (and/or manually).  You will need at least SharePoint Designer to accomplish this, but it's free (http://office.microsoft.com/en-us/sharepointdesigner/FX100487631033.aspx).  Also look on that page for links, with pictures, on workflow creation and if you have any questions about this specific workflow please respond here.
0
 
vithal_mAuthor Commented:
GreatGerm: Thanks for your reply, however i'm still unable to find an acceptable solution when it comes to workflows in SPD as I am still unable to link both lists together to get the functionality as mentioned in my original post. What are your recommendations?

Things to consider:
DepartmentList is essentially a short list of users (approx 11 entries) and their associated teams (there are three different values to represent each team).
Each task needs to be assigned to a user, and ideally I would like the Team column to be auto populated when a user has been chosen (so somehow this needs to reference the DepartmentList for this). My reasoning for this is that although I could have left the option to the user to decide which Team the Assigned To person belongs to (there are only three choices), people tend to make mistakes.
0
 
dsnider007Commented:
I am looking for this same solution. Please update. I am a SP newbee!
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
griffywiffyCommented:
Same here,

any help would be great. maybe a simple walk through in sharepoint designer.

thansk
0
 
vithal_mAuthor Commented:
I am unable to keep this question open as I need to post new questions.
0
 
JWL5537Commented:
Was anyone able to find a solution?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.