AnsweredAssumed Answered

List field

Question asked by Annette on Aug 14, 2013
Latest reply on Aug 14, 2013 by Annette

Title

List field

Post

     Hi...

     I am trying to create a list calculation taking results from other fields. 

     I have four fields , we'll call them F1, F2, F3, F4 for the purposes of keeping it simple....they are basically just where the users place an X if the field applies to them.

     I want to create a list field that combines all that have an X into one line seperated by a comma (,)....but if there is an X in the field I want to replace it with a word. 

     So if F1 has an "X" i want it to place "One", F2 has an "X" then "Two" and so on.

     I thought it was a Case function such as :

     Case (F1 = "X" ; "One" ; F2 = "X"; "Two", etc but this way it only lists the first one (Those where there was an X in all four fields only listed the first one. 

     What am I doing wrong and how do I get it to put them in one line seperating each by a comma?

Outcomes