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.
Question
Multi-select Text Field in a Formula Used to Work But Now Does Not
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.