Can you auto assign an 'Owner' depending on a status value?

Hi all, I’m sitting the second day already and can’t get what I want. The use case is following:
users fill in the forms asking for a change request, they specify the department they are from. Based on a department value a product owner of the specific department should be notified in order to approve/disapprove the request. I created a Product owner column hoping that users will be able to point the person while filling in the form but it is not possible, unfortunately.
What is the best way to solve it?

Hi @Gauhar - Is your department value a Status column? If so, you can create an Automation that if a new item is created and Status = X, then assign (person) and notify them.

1 Like

omg, it worked! :heart_eyes:
thank you so much!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.