2 Replies Latest reply on Sep 10, 2018 1:54 PM by Hari Ankem

    Matching columns to same value in another column

    Alexander James Bogart

      Hello,

       

      Ran into a challenge trying to match specific column results to identical results in different rows.

       

      E.g.

       

      Employee Name             Manager Name        Grade

      Bob                                 Alex                          2

      Fred                                Bob                          1

      George                            Bob                          1

       

      I'm using "Manager Name" as a field to sort span of control. Unfortunately, the grade for "Manager Name" is the grade of the employee, not the grade of the manager.

       

      I'm trying to create a calculated field to return "2" whenever Manager Name = "Bob".

       

      Any ideas re: an easy way to do this? \

       

      Thanks,

      Alex