Use value from other list in calculated column?

Question

I have created a number of lists in Sharepoint. Now I want to create a calculated column for one of these lists. For this calculation I need a value from another list. In Sharepoint, can you look up a value from another list (i.e. not select or fill it with a Lookup column) and use it in calculated columns?

In Excel I would solve this with Vertical Search, is there such a thing in Sharepoint?

Thanks!

Ganesh Sanap - MVP · Accepted Answer · 2022-09-17 14:15:49Z

0

This is a known limitation of SharePoint calculated columns.

Calculated column formula can only reference the column values from same list item/row. It cannot access column values (data) from other lists in SharePoint site.

Even if you use lookup columns, those are not supported in calculated column formula.

answered Sep 17, 2022 at 14:15

Ganesh Sanap - MVP

2,2901 gold badge12 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use value from other list in calculated column?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related