Dear Community,
the goal is to write a new calculated column which combine results of two other columns.
I describe the logic for understanding:
my table contains employee numbers and names of the respective supervisor of an employee.
There are two further columns in this table for a supervisor of an employee number, which cannot both be filled at the same time.
I want to enter the name of the supervisor in a new column per lookupvalue for each employee number.
Example:
| Employee Number | Supervisor_A | Supervisor_B |
| 1 | Simon | null |
| 2 | null | Tom |
| 3 | null | Brad |
You can see that only one supervisor column is filled, A or B.
So in my new calculated column I want to lookupvalue for employee 1 in the column supervisor_A and write Simon in it, but for employee 2 and 3 I want to look in the column supervisor_B and write Tom and Brad respectively.
Thank you for your support.
