Hi everyone
I want to know if i can choose more than one criteria in the same first area
For example :
If column 1 is …(then i can make a list instead of creating multiple rows of “OR” repeating same thing 30 times)
i dont know if it’s unerstandable.
Tanks for your help
Pierr
Not really. Can you give a more concrete example of what you are trying to do?
Show me what your input is, and what your desired output is.
I have a list which is the source of 8 choices.
Then the answer is written in column CHOIX EXO 1, 2…
I want to set a value (1 to 4) according to the result. (column Coeff)
If CHOIX EXO 1 is or includes several words in the list = 1 or 2 or 3 or 4.
For example : if CHOIX EXO 1 includes chenille or épaules or i want result 1.
My question is can i suggest several words in “enter value” or should i repeat the process for every word.
Thanks Darren.
Helpful as always
You’d have to repeat it, but you can do that within a single if-then-else column. It would be something like:
- If CHOIX EXO 1 includes chenille, then 1
- If CHOIX EXO 1 includes épaules, then 1
- etc…
An alternative would be to use a JavaScript column.
Ok.
Thanks
For java. I’m not that good.
How many cases in total do you have? If there are too many, JS is a better alternative.
- i found a solution renaming cells.
thanks
Can you explain what you mean by “renaming cells”? It can help people who read this topic later.
Every terms in the data list i use for the choice are renamed according to the future category i want to have. So i wrote (1) or (2) or (3) or (4) inside.
Then when user pick the choice it includes (1) or (2)…and i can have what i wanted.