value list with calculated field

[jeffw]

Hi everyone newbie here. I have a value list that has approx. 40 entries in it. What I want to do is a calculated field that is a summary of what they picked in the value list. For example say may value list has

1) Red

2) Blue

3) Green

The user picks red and blue

Then I want the calculated field to say Red,Blue

All the data is stored in one field called color but my calculated field is called ct_color. The formula currently looks like this color & "," & color. However this is not working. Thanks for the help

[comment]

Try:

Substitute ( color ; ¶ ; ", " )

[jeffw]

Sorry it didnt work. I need to correct myself it is a checkbox not a value list that I am pulling the data from. Here is what the formula looks like now:

Substitute ( color ; ¶ ; ", " )

When I click on the first box the calculated value says Red. When I click on the second value the calculated value says Red,

Any thoughts? Thanks for the help.

[comment]

Does this work for you?

color.fp7.zip

[jeffw]

Ok that is exactly what I want. So now I am wondering if there is another problem maybe relationship.

[jeffw]

Thanks for your help. I got it to work.