Hi all,
I’m setting up a project management template where two departments need access to the same project and task databases, but each department should only see their own items.
Current Setup:
- Two separate spaces (one for each department)
- Each space has views connected to the main project and task databases
- Views are filtered to show only Department 1 or Department 2 items respectively
Problem: When I create a new project in a department’s table view, it immediately disappears because new projects aren’t initially assigned to any department. Since the view is filtered by department, unassigned items don’t show up.
Questions:
- Auto-assignment: Is there a way to automatically assign the correct department when I click “New Task” in a filtered table view?
- Space-level filtering: Can I apply department filtering at the space level instead of individual table views? This would eliminate the need to set up department filters for every single view I create.
Any suggestions would be greatly appreciated!