I've got a single select field for an address, and I want to autofill a secondary field based on that selection
If 123 Street is selected, then it returns the corresponding email, etc.
I'm using the below formula, but it keeps returning info@email.com regardless of the selection.
IF(OR(Address="1234 Street",Address="1234 Road"),"Info@email.com","Info@email2.com")
What am I doing wrong?