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?