Filter on column with multiple contacts

I have a project plan with tasks assigned to multiple users. However, when I try to filter one a name. For example all tasks assigned to me it comes back with nothing. What am I doing wrong?

If I use contains and type in the name it works. However, if I use has any of and use the drop down list it doesn't return anything.

Any help would greatly be appreciated.

Thanks

Find more posts tagged with

Comments

Marcin P

Hi,

If you use contact column, it should work. If you enter names within coumn set up to standard column, then try filter with condition "contains" and enter that specific name. Then it filters by such string, so it should work too.

Sign in to join the conversation!

Quick Links

Trending discussions

Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…