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.