question

RajShekar-3515 avatar image
0 Votes"
RajShekar-3515 asked BakerKong-MSFT edited

How to get lookup column value to a calculated column

How to get lookup column value to a calculated column .

office-sharepoint-server-development
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image VaibhavChaudhari ·

Could you share the code that you have tried? Where exactly lookup is being done and where calculated column has to be added?

0 Votes 0 ·

1 Answer

BakerKong-MSFT avatar image
1 Vote"
BakerKong-MSFT answered BakerKong-MSFT edited

Hi RajShekar-3515,

Lookup columns cannot be referenced in a calculated column formula.

Supported and Unsupported Columns in SharePoint Calculated Column Formula

As a workaround, you can simply user workflow or event receiver to update the target column based on the lookup field. For more details, please refer to Using Lookup Field in Calculated Column SharePoint

Best Regards,
Baker Kong

· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BakerKong-MSFT avatar image BakerKong-MSFT ·

Hi @RajShekar-3515,

Regarding this issue, Is there any other concern? Please feel free to talk with us if you have other SP related question, we're glad to help further.

Thanks
Baker Kong

0 Votes 0 ·
BakerKong-MSFT avatar image BakerKong-MSFT BakerKong-MSFT ·

Hi @RajShekar-3515,

Regarding this issue, we have not heard from you for a long time. If the above info is helpful to this question, it would be appreciated if you can mark it as an answer so that others who stuck in similar issues could get answered quickly.

And if you want to receive the related email notification for this thread, please follow the steps in our documentation to enable e-mail notifications.

Thanks
Baker Kong

0 Votes 0 ·