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 returned in "sfgLifecycle" and times it by ten, is this possible? if so, how do i go about doing it?
2 Replies
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.
You can't reference a lookup column in a calculated column formula. However you could use a flow in Power Automate to update the item with the sfgLifecycle x 10 value. An example of this is below and the x10 column is a number column:
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
