Solved

Need help with calculated column formula in SP 2010

Posted on 2011-09-27
3
522 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

919 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now