Fill in another sheet based on a certain topic.

I am building a app for a daily tracker of issues. I want to be able to copy certain issues to another sheet each department is in charge of. So when using the app you will select a disscusion point like "HR related issues" and then next field is a text field to put the issue we are having. I want any time the discussion point is selected it copys those issues to another sheet. I was thinking maybe a Bot setup. 

0 1 116
1 REPLY 1
Top Labels in this Space