Sharepoint-list lookup-column changes type of additional columns

Question

Hi,

issue: type of column changes when added to list by lookup-column as an additional column.

steps to reproduce the issue:

1. create list with 2 columns - one of type text and other of type number
2. create 2nd list
3. create a lookup-column in list 2 and reference to the text-column in list 1
4. click additional columns to be added and choose the number-formatted column in list 1
5. see what comes up - in list 2 the number-formatted column appears as text - no calculations possible with that number which comes as text

Any possible workaraound to be able to do some calculation with that column?

Answer 1

Hi @Michael Lüssem ,

You should be aware of the lookup field can’t be referenced in

• SharePoint Calculated Column Formula, and
• SharePoint Column Validation.

Supported and Unsupported Columns in SharePoint Calculated Column Formula

Below are some of the available workarounds that helps you to use Lookup Field in Calculated Column SharePoint Formula.

• Using Choice Field instead of a Lookup field.
• Using SharePoint Designer Workflow.
• Build SharePoint calculated column formula using Custom code

See this for details: Using Lookup Field in Calculated Column SharePoint.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.