Case or IF doesn't work from Listbox?

  • 0
  • 1
  • Question
  • Updated 6 years ago
  • Answered
Hi,

I have a field called Branch which is a text drop down box with a mixture of number and/or alphanumeric choices.

I have another field called Branch Name which is a formula text field.

However if I put the below formula into the Formula field it doesn't seem to work - it doesn't error it just doesn't populate it. I expect if I pick 10 from the drop down that it will show 'UK', else zero.

If([Branch] = "10", "UK", "0")

I also tried this with using a Case statement but it behaves in the same way.

Is there something else I should do?

Photo of stuaz

stuaz

  • 10 Points

Posted 6 years ago

  • 0
  • 1
Photo of Mark_Shnier

Mark_Shnier

  • 640 Points 500 badge 2x thumb
It should work with your formula.  Is there any chance that the "10" is actually "10 " with a trailing space in the drop down choice?  Does it work for the other choices?
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,516 Points 4k badge 2x thumb
If you want to contact me offline I'm happy to help you look at this on screen.
Photo of stuaz

stuaz

  • 10 Points
Nope it doesnt have any trailing spaces. And the same no matter what choice i choose.
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,516 Points 4k badge 2x thumb
Required a re-build of the Text Multiple Choice field and Formula, which could have broken when the Multiple-Choice Text field was converted from a Multiple-Choice Numeric field to Text.
Photo of stuaz

stuaz

  • 10 Points
Thank you again Laura! :-)