locked
Sharepoint list - Calculated field check and flag RRS feed

  • Question

  • Hello,

    I am trying to configure a calculated field B, which checks another 'Multi-value' look-up field A. Is there a calculation formula by which Field A can check a string ABC and flags the field B with a 'Yes'. if  the value is not found  in Field A, Field B should mark a 'No'.

    Please advise,

    Thank you!

    stct.


    stct

    Wednesday, June 15, 2016 8:18 PM

Answers

All replies

  • hi

    because you canțt use lookup columns in calculated columns

    a workaround

    In the lookup column create a calculated column which will check the neededd value

    Next in the destination list , add ( check ) that calculated column from lookup column


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Wednesday, June 15, 2016 8:53 PM
  • Hi Romeo,

    Thank you for the reply. Unfortunately, I am not sure if I understood the exact step, as I am not an expert on this configuraiton. My source column is "Choice". 

    How do I create a Calculated column in the lookup column? Can you advise on this please?

    Thank you!


    stct

    Wednesday, June 15, 2016 9:10 PM
  • Hi stct,

    By default, we can't found the lookup field in calculated field Formula. As a workaround, we can create a Yes/No field(named FieldB, set default value is No), then create a SharePoint designer workflow to set the FieldB value base on the FieldA value.

    More information:

    https://tjendarta.wordpress.com/2013/02/22/utilize-lookup-column-in-calculated-column-sharepoint-list-libraries/

    https://sharepoint.rackspace.com/calculated-columns-tutorial

    Best Regards,

    Dennis


    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.


    • Edited by Dennis Guo Thursday, June 16, 2016 6:16 AM
    • Proposed as answer by Patrick_Liang Thursday, June 23, 2016 9:17 AM
    • Marked as answer by Patrick_Liang Thursday, June 30, 2016 9:01 AM
    Thursday, June 16, 2016 6:11 AM