Get extra Column with sharepoint Lookup column

2
votes

I work on SharePoint server 2013, in my case i create 2 list (list A and list B) list A contain 2 columns : Title, Status(Type: Choice) list B contain 2 columns : Title, Porject(Type: Lookup to list A) i want to get one extra column (Status) with this lookup field, but i noticed that the lookup column can only see columns with type (Single line of text)

is there any solution to get this Choice column as extra column with a lookup field?

1
sharepointsharepoint-2013

1 Answers

1
votes

In listA, you can create a calculated column that contains the contents of the 'Status' column,
Then, You can add this calculated column to listB as an extra column.