How can I apply logic to a few drop downs in a form without having to apply logic to all options?

Alicia D

I am trying to do conditional logic where I have 35 different manufacturing plant locations and 5 of them are Canadian. The first dropdown I have is for them to select a location, and I want to have conditional formatting for the Canadian plants so that when they enter the dollar amount they get the Canadian dollar box. I don't know how to do this without me having to set conditional formatting for ALL of my plants to use the other boxes that aren't Canadian. Because I don't wan the US box to show on the Canadian ones either. When I try to do the logic for the 35 locations, it won't allow me because it is too complex. Please tell me there is a way around this without having to do 2 separate forms. Thanks!

Matt Lynn ACT

@Alicia D I think you might want two different columns, one for USD and one for CAN. Then you'd do logic to show one field or the other based on the location selected.