Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions