how I Create a calculated column in SharePoint and writing formula using lookup columns, other.
I want to create a calculated column that the field in the formula I use lookup column
plz, help me!
-
how i can use workflow nintex– farbod teCommented Feb 13, 2017 at 12:26
Add a comment
|
1 Answer
Unfortunately, Lookup columns cannot be referenced in a calculated column formula.
Check The Supported and Unsupported Columns in SharePoint Calculated Column Formula.
The suggested workaround
- To use a workflow/event receiver that copies the lookup column value into an another column with a text data type.
- Then use that copied field in your formula.
Check the detail steps at How to use Lookup field in SharePoint Calculated Column Formula.
answered Feb 13, 2017 at 11:31