Sorting items into groups according to form responses

Hello,

Is there a way to have items created via a form be sorted according to a specific response in the form? I have a board I am using to track time off requests, and due to multiple people using the same board, I wanted to break down requests by manager into different groups within the same board. Currently, I have a line in my form to select the manager of the employee requesting, and automations built to sort the request into different groups when the manager status column is changed to the manager’s respective names. After trying a few submissions, the requests are not being automatically sorted (I’m assuming it’s because the manager status is showing up already populated and not being changed) However, I am looking for this automation and sorting to take place upon form submittal. Is this possible? Any recommendations? Would it be better to have separate boards for each manager? Thank you.