Currently, I solved this by writing a Python Lambda function in AWS that runs every minute. It checks all records for our “ongoing projects” table. For each record, it checks what the current status is and who the current assignee is. If the assignee is different from the one that should be there, it changes the assignee to the right one.
This allows us to automatically have assignees change based on which phase the project is in. It would be incredible to have ‘if this, then that’ built into some of the column value types.
Is there any possibility of this happening?
EDIT: I can share the code if anyone comes across this and is wanting to do the same thing.