I have a list that utilizes 3 choice columns with each is configured to allow for multiple selections. Each of these columns represents a type of system change (application change, database change, or server change), but 90% of the time only one type of change is made for a particular system change. However, the other 10% of the time 1 change can affect multiple types of systems. If I display all 3 columns in my web part, much space will be wasted because it is likely that 2 of the 3 columns in each row will be empty. So, what I'm trying to do is concatenate the 3 choice columns such that all selections appear from any of those 3 columns is combined in a new, single column. You'd have something like the following: Application Changes: "App1" & "App2" Database Changes: None Server Changes: "Server 3" System Change (new column) would display: "App1, App2, Server 3" When I try to use the 'Concatenate' function as a calculated column, I get an error saying this is impossible because of the column type being acted upon. Is there any other way to do this?

Untested, I would think, theoretically, that one could use an on-change triggered SPD Workflow to perform the concatenation into the other field. The other field would just be a single line text, and not a calculated field.Steve Clark, MCTS | Twin-Soft.com