Hello,
I'm a newby on this area so i hope someone can point me in the right direction.
I made an excel document on Onedrive (business) created a Form and got the 2 connected. So that works.
In the Form, the user can choose in which building they work in. On this data i would like spread out the data across differnt scheets. So that all entry's from Building 711 come in sheet "711" and for building 712 in sheet "712" and so on.
I tried it with a switch, first off it looks good, it lets me choose the right dynamic content, but wenn i test it fails. Is the switch in the wrong place?


