I am trying to write a SWITCH formula, as below:
The customer number column is TEXT column, which is linked to a submission form. I cannot get this formula to work, I have no idea why.
I have another formula, wherein the lookup column is a dropdown menu, which works beautifully, with the same parameters
Please guide and help