Nov 28 2022 03:09 AM
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
They are names of the month and all store Numbers.
I have the following content types
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
Nov 28 2022 10:35 AM