Hey everyone!
I’m managing a project with around 40 part-time team members and could really use some help with setting up a simple but effective task allocation system.
Here’s what I’m hoping to achieve:
- I want to create a task sheet where, once a user marks the “Status” column as “Claimed,” the task either disappears or becomes locked so that other users can no longer edit it (but they can still view it).
- As the manager, I’d like to be able to continuously add tasks to this sheet, keeping my workload minimal.
The goal is to reduce the time spent manually managing who’s claimed what, so the system becomes a bit more self-sufficient. Does anyone know a good tool or method to set this up? I’m open to using spreadsheets, scripts, or any other automation tools that might help make this easier.
Thanks in advance for your suggestions!