Retrive data from another column.
- 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
Answers
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.- Proposed As Answer byMohit9900 Wednesday, November 04, 2009 4:49 AM
- Marked As Answer byLambert QinMSFT, ModeratorThursday, November 05, 2009 6:31 AM
All Replies
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.- Proposed As Answer byMohit9900 Wednesday, November 04, 2009 4:49 AM
- Marked As Answer byLambert QinMSFT, ModeratorThursday, November 05, 2009 6:31 AM
- Follow the steps mentioned by Ashwin.
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.- 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 - That mean I can not copy Assigned to data into Service Representative??
- 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."
