Fill a column by combining values from two columns and an auto number ?

Hi,

According to your description, you want users input values for “Designation” and “Department” columns of the “Department Employees” list, then make the “Employee ID” column to be filled automatically based on the values of other two columns.

SharePoint Designer workflow can meet your requirement.

Steps in details will be something like this:

1. Create a Lookup column named “Designation” in “Department Employees” list lookups to the “Designation Name” column of the “Designations” list, in the Additional Column Settings, add a column to show an additional field “Desig ID”.

In my sample below, I create a column lookups to the “ID” column of the Announcement list, add a column to show “Title” field:

2. Create another similar Lookup column “Department”;

3. Create a Text column “Employee ID”;

4. Create a List Workflow in SharePoint Designer 2010 for the “Department Employees” list.

In this workflow, we can retrieve the Lookup column value with the additional field value, there is also a workflow action “Set Field in Current Item” which can modify the value of a column in the current item.

Then set the workflow to start when there is item added to this list.

The links below will provide more information about SharePoint Designer workflow:

http://ift.tt/1eZTlJU

http://ift.tt/1oXV0bK

http://ift.tt/MHsABr

Workflow actions in SharePoint Designer 2010 : A quick reference guide

http://ift.tt/1eZTlJU

Feel free to reply if there still any questions.

Best regards,

Patrick

---

Patrick Liang

TechNet Community Support