Filter for Current User with multiple contact column

Michael G.

I have created a sheet filter "my todo´s" for the current user.

This works if only one contact is entered in the filtered column.

But we have enable multiple contacts for that colum.

Is there a possibility to build a filter "contains the current user"?

David Joyeuse

Hi @Michael G.

The first thing that comes to my mind is to create a report out of the sheet and make the report viewable by connected user.

That should do it.

Andrée Starå

Hi @Michael G.

It also works in a sheet, but you'll have to select has any of and Current User.

Did that work?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

David Joyeuse

Hi @Michael G.

The first thing that comes to my mind is to create a report out of the sheet and make the report viewable by connected user.

That should do it.

Michael G.

Hi @David Joyeuse

Thank you - this works well.

In my opinion, it should also work within a sheet.

But our urgent problem is solved now 😀

Thank you again and kind regards

Andrée Starå

Hi @Michael G.

It also works in a sheet, but you'll have to select has any of and Current User.

Did that work?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Michael G.

😲

Hi @Andrée Starå

I am really astonished.

I am extremely sure that this did not work last week.

It is magic ... 🐇🧙‍♂️

But okay - problem solved - requirement fullfilled.

Thank you very much - stay healthy 😀

Michael

Andrée Starå

@Michael G.

Haha!

You're more than welcome!

https://media.giphy.com/media/W5eNbniUYKoyk/giphy.gif

Victor Gentile

I'm having this problem as well... I have myself and another user in the column. When I filter by has any and current user it will now show up.

Andrée Starå

Hi @Victor Gentile

I hope you're well and safe!

Strange!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!