Hi everyone,
I'm trying to map all tasks and collaborations for each employee to help them manage their workload. For collaborations, multiple employees can be tagged in a single cell.
My first attempt was to use a simple IF(cell = "NAME OF THE EMPLOYEE", 1, 0). This works only when one employee is tagged in the cell. However, it doesn't work when two or more employees collaborate on the same task.
So, I got the idea to use the CONTAINS function. You can see an example here: I tagged myself in the collaboration row and then applied this basic formula. However, it always returns FALSE. I double-checked the spelling, but the issue persists.
Any ideas on what might be causing this?
Thanks!
