Forum Discussion
Sharepoint List Lookup question
Hi I have a Sharepoint list which uses columnn "sfg" as a look up, it then returns "sfglifecycle" for instance. I want to add a calculated column that references uses the figure that's been r...
Calculated columns in SharePoint cannot directly reference values from lookup columns.
To perform calculations using data from a lookup column, you'll need to use automation tools like Power Automate to retrieve the value and apply the necessary logic.
Alternatively, while not ideal, if you don't want to use automation, you can add a number field in the parent (lookup) list and store the pre-calculated value manually. Then, include this field as an additional column in the lookup. This allows you to reference the value more easily in your current list.