CONTAINS formula with contact cell
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!
Answers
-
Try using Has:
=IF(HAS(Collaborateurs@row; "Frederique Goulet"); "True"; "False")
-
Hi Nic,
It does work!! Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!