Forum Discussion

Quenril's avatar
Quenril
Icon for Resolver I rankResolver I
2 years ago

Related lookup column with added time component

Hello,   I have a 'Consultant lookup' table which contains the names of Consultants, the Practice they are in, and the date from which they were in that team. Names are repeated due to promotions o...
Need Help
Quenril's avatar
Quenril
Icon for Resolver I rankResolver I
2 years ago

Hello Zhengdong,

 

This is so helpful and very, very close to what I need... in some instances the results includes multiple Practice names. Ideally I want only the Practice name which the Consultant is currently sat in... is there a way to remove the additional unecessariy information? I only want the last Practice information returned for each Consultant....

 

thank you

Quenril 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Quenril 

     

    What does it mean that the result contains multiple practice names, and does it mean that there are several practices in a cell?

    Please provide screenshots or other forms of the instances where the results include multiple Practice names and the data that these rows refer to in the Consultant lookup and Client meetings tables.

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.