Make a column 'calculated value' based on a 'Lookup' Column RRS feed

  • Question

  • Hello,

    I'm trying to filter a list 'orders' on a column 'customer'.
    My issue : I can't display a selection of customers (see below :)  )
    My first attemp was to create a display of the list 'orders' and filter the 'customer' column :
    equal to
    <customer's name>
    This was not a efficient method because after 10 filters, i can't add more filters (SharePoint limit, i guess).

    Next, I tried to change list parameters by adding a column 'calculated value'.
    I expected to do a formula like this : =OR([customer]="Customer1";[customer]="Customer2") with a return value TRUE or VALSE.
    But, the column 'customer' is not available in the column list.
    When i look the 'customer' column type, i see that it is a Lookup column.
    (indeed, the customer name comes from the 'customers' list)

    How to make a column 'calculated value' based on a type Lookup column ?

    Tuesday, January 10, 2017 9:01 AM


All replies