I have a Sharepoint (2010) list, where I have a column that's supposed to be calculated based on four previous columns.
Each of these columns are selection box columns, each with three options, and you can only select 1 option.
- Column 1; option1, option2, option3
- Column 2; option1, option2, option3
- Column 3; option1, option2, option3
- Column 4; option1, option2, option3
Option1, 2, and 3 are all the same value in the different columns.
Now, the calculated column is to be calculated like this:
If all the columns are option 1, the resulting column should be option 1.
If just a single one of the columns are set to option 2, then the calculated column should be option 2.
Finally, if just a single one of the columns are set to option 3, it will supersede the option 2, and the resulting column's calculated outcome should be option 3.
Is this possible to do?
Please note, that the network this is to be done on is not connected to the internet, that Sharepoint Designer is not implemented, nor can it be, and installing scripts are completely out of the question.
Infopath and Access are available, though.