Gantt chart - help with filtering multiple columns.

Guillaume

Hi,

I have a sheet with all of our projects listed by rows. I have created different columns per job title and have assigned users depending on who does what.

Assigned roles can be different from project to project so I want to create a filter, per user, that lists all assigned projects and the role coming with.

I have other data to filter, so it's not possible to used the "All conditions" or "At least one condition" parameter.

Is there a way to manipulate filters with "OR"?

Thanks

G

Andrée Starå

Hi @Guillaume

I hope you're well and safe!

Unfortunately, it's not possible at the moment to use OR in a sheet filter, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could use a report instead.

Would that work/help?

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 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!

Andrée Starå

Hi @Guillaume

I hope you're well and safe!

Unfortunately, it's not possible at the moment to use OR in a sheet filter, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

As a possible workaround, you could use a report instead.

Would that work/help?

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 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!

Guillaume

Thank you @Andrée Starå , yes the Report filter potential really helps here.

Cheers

Guillaume

Andrée Starå

@Guillaume

Excellent!

You're more than welcome!