Solved

Need help with calculated column formula in SP 2010

Posted on 2011-09-27
3
526 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:MisUszatek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Expert Comment

by:irinuc
ID: 36716100
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
 

Author Comment

by:MisUszatek
ID: 36717195
Hmmm... I believe that this is exactly what I am asking for. How the formula would look like then?
0
 
LVL 9

Accepted Solution

by:
irinuc earned 500 total points
ID: 36717373
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

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question