Iโm currently looking into setting up a workflow queue for my team connected to my master job log spreadsheet. My thought was to have two tabs, one with available projects (rows with no team member listed in my job log) and another tab listing out that specific userโs claimed projects and due dates (rows that have that specific user listed). I would like to have this as an open first-come-first-served queue possibly with a โClaim Project?โ checkbox. The first user to click this on a given row would then ideally update the team member column in the master spreadsheet with their name, and hence removing this from the Available Jobs list from other users. Currently my job log has each userโs name as a different option in a dropdown window. Is there a way to either trigger this selection via checkbox, or have this dropdown menu limited only to that userโs name? Iโve seen some information pointing me to the USEREMAIL() function, though Iโm still trying to wrap my head around integrating this.
User | Count |
---|---|
35 | |
31 | |
28 | |
23 | |
18 |