# Discussions

View Only

## Formula Help

• #### 1.  Formula Help

Posted 12-12-2018 20:55

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 statements looking for the ?B?s and another Formula ? Text field with the results. Tried Case & If but can?t seem to get it.

Thanks

Mike

• #### 2.  RE: Formula Help

Top
Contributor
Posted 12-12-2018 21:05
What do you mean to "extract".  A report?
Just make a report with 10 "any" conditions.

or else make a field with

[Field 1] = "B"
or
[Field 2] = "B"
or
[Field 3] = "B"
etc

or
[Field 10] = "B"

Then you have a clean hook for any reports

• #### 3.  RE: Formula Help

Posted 12-12-2018 21:25

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

• #### 4.  RE: Formula Help

Top
Contributor
Posted 12-12-2018 21:33
There is not a naive way to have a conditional multi select drop down in Field B.  By that I mean that if the user chooses Dog, then a conditional drop down can offer up only Dogs breeds, and then the use may select 1 dog. and that can be the field Choice 1.

Then you can have a separate Conditional drop down, also set by the same initial selection of Dogs in field A, and then the user can once again choose a Dog breed as Choice 2.

same for choice 3.

Then if you like you can use a formula field to concatenate them all together n a comma separated list.

• #### 5.  RE: Formula Help

Posted 12-13-2018 01:04
Thank you for the info, I thought that might be the case. What I tried was multiple if statements to pull out the choices, then a formula text field to concatenate them. It worked somewhat, but if you give people 10 places to pick from 3 choices it makes for a pretty ugly outcome. Plus I had 2 more that had 15 fields. Thanks again, moving on to the next stumbling block.