Need help with calculated column formula in SP 2010

I have a list with 3 content types. The list also has a Category column different for each content type. I would like to have a calculated column with that category for each content type so when i have a view with all content types I can have just one Category column instead of 3 for each content type. I tried a couple of ideas I had but I either get a formula error or #VALUE! in that column.

Is it doable? How should the formula look like? Thx.
MisUszatekAsked:
Who is Participating?
 
irinucConnect With a Mentor Commented:
I might have missunderstood you sorry.

what i used in this situation was something like this.
I have the calculated column T1 in content type 1 and calculated column T2 in content type 2
(both of type single line of text)
I created a new column, calculated, T3 (in both content types) and the formula on it is
=T1 & T2
0
 
irinucCommented:
Hi,

just asking: wouldn't be an idea to have another calculated column that is composed of the 3 columns from each content type.

cya,
0
 
MisUszatekAuthor Commented:
Hmmm... I believe that this is exactly what I am asking for. How the formula would look like then?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.