hi @Rutty
I have created an app that does exactly this (and a little bit more). The recipe sentence like this:
and off course you can build further:
I call this app “Status Controlled Groups” as setting the status (in my example to “Done”) advance the item to the next group and reset the status (in my case to “Assigned”). I am wondering if you want to beta test this one while I am finishing documentation and register the app for the monday.com marketplace.
I am also wondering if you (or other people reading this) wants to combine this app with another app that is in early stages. This app will move people listed in one column to another column, based on a status. For example: you can the app described above to move an item to the first reviews phase (=Group) and at the same time you move people listed in people column “Reviewers” to the people column “Owners”. When the reviewer is happy, she/he set the status to reviewed and the item is advanced to the next group (e.g silver documents) and the people listed in column “Authors” are copied to “Owners”. Combined with board level permissions on the Owner column, this will give you a system where authors and reviewers transfer ownership of an item.
Let me know.