Forum Discussion

JackDoucette's avatar
JackDoucette
Qrew Member
7 years ago

Multi-select Text Field in a Formula Used to Work But Now Does Not

Hi everyone,

I have a formula - text field that reads as follows:

If([Market]="Arizona",ToText([Target County - Arizona]),
If([Market]="Tampa",ToText([Target County - Tampa]),
If([Market]="Miami",ToText([Target County - Miami)]),
If([Market]="New York",ToText([Target County - New York]),
Etc.

The formula used to work fine and would pull in applicable counties from the Target County fields (These are multi-select fields). However, now I am getting an error message that reads "Expecting number/text/bool/date/datetime/timeofday/duration/workdate/user/userlist but found textlist". I thought the "ToText()" function would convert the multi-select field into a text field, so it can be used in a formula. Am I missing something?

Thanks for any advice you may have.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Your formula likely saves and that is the true test. The formula editor is giving a false warning.  If you like you can pit in a support ticket to say its a bug in the formula editor, but I imagine they know about it. I think that crept in on the last release.
    • JackDoucette's avatar
      JackDoucette
      Qrew Member
      7 years ago
      Thanks so much for the advice and quick response! The formula saves and appears to be working properly, so it is good to hear that it is just a bug in the formula editor. Thanks again.