Allow lookup columns brought up from different list into calculated columns
Dear Microsoft, this limitation causes a huge impact in our organization - we have been trying to migrate from MS Access into Share Point due to the collaboration it brings, but the limitation of not being able to use "lookup columns" from other lists into "calculated columns" is pretty bad. It affects negatively our ability to compare and do calculation with values from different fields. The whole purpose of MS Access is to run these queries, but since MS shifted to Share Point we thought that was possible as it not. Please do what it takes to make this happen!
I appreciate your support!
Regards,
Harry

19 comments
-
Anonymous commented
This feature would be very helpful.
-
J Bedford commented
Why this doesn't just function like a SQL View is beyond me.
-
Ruben Wills commented
Definitely would like to see this as a feature. It would open up so much possibility for list functionality.
-
Rob Elliott commented
As a workaround (or as an even a better solution) this can be achieved with Power Apps as you can have multiple data sources, do calculations on them and write the data back to the SharePoint list.
-
Anonymous commented
This is pretty poor that what would seem to be a fairly basic aspect, such as being able to calculate based on looked up values, is not available. Do not understand why MS enabled viewing the data in a field if there is nothing you can do with
-
Carol Brown commented
I need this ASAP. I am trying to evangelize the use of SharePoint and Forms and this is limiting my ability. Does anyone know of a work around (in the list) not with Flow but may be JavaScript etc.
Please make this available
-
Michael Tondu commented
How is this not possible yet?? 1 trillion $ in market cap for such limited software is beyond me.
-
Kamyrion Lopez commented
Just why does this not work? From a user perspective this is a bad miss.
-
Anonymous commented
As mentioned of many other users I have just faced this issue as well. Really annoying when you by a choice in a column need to pick data from one of two SP lists (Lookup Columns). Any official MS status on this issue?
-
Benjamin Gilardi commented
Allowing lookup columns in a calculated field would make views significantly more flexible and would eliminate complicated workflows.
-
Anonymous commented
I agree - this really is a serious requirement. It's one of the main reasons I cannot move a lot of our Excel Spreadsheets to a SharePoint list
-
Anonymous commented
RIght now we have to rely on Flow to transfer the data from lookup columns to columns we can use in calculated columns. This takes a great deal of time and makes our Sharepoint list almost unusable. What is stopping Sharepoint from allowing data in lookup columns to be used in calculation columns?
-
Starfish Health Wellbeing commented
I REALLY need this
-
Anonymous commented
Really, really, really could use this right now. Need to make some complicated calculations and linking between list and library and back again really, really, really could use look up to include calculated columns and multiple choice columns.
-
rtsrt commented
Please make this available in SharePoint. It is incredibly frustrating to have to create all kinds of SP Designer Workflows to do such a simple process as copying the contents of one column into another for tools such as Power BI.
-
David commented
Is there any update on this issue? Having to build workarounds with new columns and workflows is an unnecessary headache for everyone.
-
Bernd Holy commented
This feature would make life much easieras the workaround would require us several runs of a flow.
It's also much more administration work to maintain all those workaround flows. -
Raymond Kilgariff commented
Yes absolutely along with the networkdays function in calculated columns
-
JoeD commented
I agree, this is pretty silly.