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!
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.
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
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.
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.
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
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
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.
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.
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
I agree, this is pretty silly.