I would like to correct the below formula so I can have the team of each employee by month based on his entry date and exit date with no time limitation.
The way the formula is currently it does not take into account the fact that I have 2 lines in my transaction list for an internal mobility. It only take into account the latest subteams.
Here is an example:
‘Dataload HR tool - Employee.’ is my transaction list with all the info by employee.
Currently for this employee, i have the following result.
But it should be “Finance & Planning” team until jan 24 and from Feb 24 until the end “Product data”
The data will be updated each month on the latest version of the ‘Dataload HR tool- employee’.
Thanks for your help
Best answer by francoisView original