Retrive data from another column.

Question

Hi all,
     I have created one subsite using HelpDesk Template on the site of MOSS. This template is providing 'Create a Service Request' form. First we can add Assign To in Service Request form then after editing the added item we can add 'Service Representative' also.
     But I want to auto retrive 'Service Representative' data from Assign To column.
Can anyone Please helm me out to find solution.


Thankx in advance

Answer 1

You can use calculated column..

Follow below steps:

1. Delete Service Representative column
2. Now Add Service Representative as a Calculated column
3. Select Assigned To from Insert Column list and click on Add to Formula link
4. Click on OK button 

---

Cheers, Ashwin B.

Answer 2

Follow the steps mentioned by Ashwin.

Answer 3

Thank you for reply but..

1. If the Service Representative column will deleted then the other links will be disturb like dashboard.
2. And I am trying to create a calculated column but it is not showing Assigned To in Insert Column list .
3. And also Assigned To column is not able to see in lookup field.

      Can you please help me to resolve this problem.

Answer 4

you cannot do what you want to do.
columns do not support data types...the "Assigned To" column is a data type

here's more information about using calculated forumlas

http://office.microsoft.com/en-us/sharepointtechnology/HA101215881033.aspx#3

Answer 5

That mean I can not copy Assigned to data into Service Representative??

Answer 6

yes. whenever I tried referencing the "assigned to" column to the "service representative" column, it gives me the following error.

"One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas."