Allow lookup columns in calculated columns
I need to use a lookup column in a formula of a calculated field.

5 comments
-
Marcelo Sauaf commented
definitely a MUST, it's usual to employ calculated columns to create items' (friendly) PRIMARY KEYs
-
YatinP commented
Please please please add this feature. It will stop requiring a Designer Workflow for such small functionality.
-
Stephen C Thompson commented
The same idea has been presented in this suggestion, "Allow lookup columns brought up from different list into calculated columns", https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/13981188-allow-lookup-columns-brought-up-from-different-lis
Since there is no way for us to merge duplicate suggestions I recommend voting for the instance that currently has more votes.
-
Ryan Caldwell commented
Very Disapointed - I found a work around for a problem I discovered where a choice column is not able to be used by lookup column selection - this was by creating a formula column to put text at the front of the choice data in the main list - this let the lookup column be able to select it & I could bring the data from this list into child list. I then wanted to use RIGHT(LEN-MIN(FIND({},&""))-)) formula to display the numbers only - like you can in excel. But Sharepoint can't use a lookup column in calculated columns - so it can't be automated...
2 very silly restrictions - 1)can't use lookup to display data in another list from a choice column. 2)a work around with formula is possible - but - you can't use a lookup column in calculated columns so as to be able to extract the needed data out of the lookup column..........Really really disappointing.
-
Mohamed El-Qassas commented
Unfortunately, The lookup column is not supported in
- SharePoint Calculated Column Formula.
- SharePoint Column Validation.For more details, Please, check
- The supported and unsupported columns in SharePoint calculated column formula at https://spgeeks.devoworx.com/supported-fields-in-calculated-column-sharepoint/
-------------------------------------------------
The available workarounds are mentioned in more details at
https://spgeeks.devoworx.com/lookup-field-in-calculated-column-sharepoint/