Gantt chart - help with filtering multiple columns.
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"?
Help Article Resources
Check out the Formula Handbook template!