Forum Discussion

Brass Contributor

Oct 13, 2020

Solved

SharePoint Online Column Calculation

Hello, I have created 2 lists on my SharePoint Online page. In the 2nd list I created a LookUp column to a number column from the 1st list. Now I want to create a calculated column in the 2. list,...

Lists

SharePoint Online

ganeshsanap
Oct 13, 2020
Silas_Muth , Lookup columns are not supported in Calculated column formulas.
Workaround: You need to create a Power Automate flow (or designer workflow). Run the workflow on item create and item update. In workflow you can update the column in list 2 with the number value from your lookup column.
Please click Mark as Best Response if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Like.

ganeshsanap

MVP

Oct 13, 2020

Silas_Muth , Lookup columns are not supported in Calculated column formulas.

Workaround: You need to create a Power Automate flow (or designer workflow). Run the workflow on item create and item update. In workflow you can update the column in list 2 with the number value from your lookup column.

Please click Mark as Best Response if my post helped you solve your issue. This will help others find the correct solution easily. It also closes the item. If the content was useful in other ways, please consider giving it Like.