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"?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!