Formula Help
I have 10 Text ? Multiple Choice fields that use the same 3 choices; A, B or C. I want to extract just the ?B?s. I?m looking for a better way than 10 separate Formula ? Text field with if statement...
Forum Discussion
Thank you for responding so quickly, after posting I realized I wasn't clearly explaining what I want to do. The users pick choice A, B or C from Field 1, then choose from a conditional drop down in Field 2. I want to take the results of a B choice in Field 1 from Field 2 and combine them in another text field. For example; if the choices in Field 1 are: Dog, Cat & Bird & the user chooses Dog he only can pick different dogs. I want to pull out just the dog picks for the text field which would be something like "customer prefers [choice 1], [choice 2], [choice 3]". Hope this helps
Mike