Skip to main content
Question

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

  • March 6, 2019
  • 0 replies
  • 21 views

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.
This topic has been closed for replies.

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.