I want to insert different form buttons linked to different sheets to store data but it only selects one sheet and doesn’t let me link it to a different one although it gives me the option to.
Eg: I have 3 form buttons. One for Service A, Service B and Service C. I made 3 sheets for these 3 services with different column headers. Now I want to link Form A to Sheet A (Service A), Form B to Sheet B (Service B) and Form C to Sheet C (Service C). When I set the destination of Form A to Sheet A, Form B and C too get linked to Sheet A. Similarly when I change the destinations of Form B and C to their respective sheets, it changes the destinations for all 3 of the Form buttons.
Can someone help me out so that I can get this sorted out? I’m not sure if this is a bug or if I have missed out on something.