Forum Discussion
VStar19
Nov 28, 2022Copper Contributor
Updating Content Types via calculated field.
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
- Content Type 1
- Content Type 2
- Content Type 3
- Content Type 4
- 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
- iamsarahBrass Contributorwhat do you mean with "send Content Type x value of Jan to 1 else 0"?