@ankit_cheeni So here is where I am struggling. Data is provided to assign each person to a role - which is a text. However to do a LOOKUP you need that to be a date or list. The Role list is just displaying the Role name and Role code. There is no correlation I see between the list information to data information for employee detail. Am I needing to add an additional layer to the SYS08 to add the Role Code? If I convert Role to the Format of List, the formula populates a blank.
... View more