Updating Content Types via calculated field.

Copper Contributor

Hi. 

I have a sharepoint list with several content types, the content types all consume majority of the same site columns. 

E.g. i have the following site columns

  • Jan
  • Feb
  • Mar
  • ..
  • Dec 

They are names of the month and all store Numbers. 

 

I have the following content types

 

  1. Content Type 1
  2. Content Type 2
  3. Content Type 3
  4. Content Type 4
  5. Content Type X

And all of the above content types use the site columns mentioned above. 

 

For Content Type x, i need it to be a calculated column based on the values on Content Type 1. 

 

So

if [Content Type 1] value Jan > 10, then send Content Type x  value of Jan to 1 else 0

if [Content Type 1] value Feb > 10, then send Content Type x  value of Feb to 1 else 0

if [Content Type 1] value March > 10, then send Content Type x  value of March to 1 else 0

 

Can this be acheived?

 

Thanks in advance

 

 

1 Reply
what do you mean with "send Content Type x value of Jan to 1 else 0"?