Automation trigger - copy row to one of several sheets based on cell value
I have a form linked to the new request sheet. Based on the request type I want the row to be copied and placed in a sheet which corresponds with the request type. There are ten different request types and ten different sheets. For example there is a request type for Rotation, New Hire, etc. Then there are sheets named Rotation, New Hire, etc.
I have set an automation to trigger when "rows are added" and the action to copy the row to a sheet. I currently have the first condition when the request type "has any of" Rotation to copy the row to the Rotation sheet. I have a second condition, under the same trigger, when the request type "has any of" New Hire to copy the row to the New Hire sheet.
When I test the automation by submitting a form the row is copied to the Rotation sheet when the request type is Rotation. But when I submit the form with the request type as New Hire nothing is copied over to the New Hire sheet.
Do I need to have a separate trigger for each condition? Or any suggestions as to what I need to look for that might be wrong with how I set up the automation.
Thank you for your time and response.
Help Article Resources
Check out the Formula Handbook template!