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



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




      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? \