Forum Discussion
Sharepoint column value (status) based on other multiple column values
Dear Team, I have a very basic knowledge of SharePoint and therefore requesting for help for the below scenario. I want to create a column on a sharepoint list to show the status (Approved, Rejecte...
Also with the code that I used, I am only able to use 2 types of statuses, but wondering if more than 2 status (results) could be achieved based on different combinations of selects.
e.g.
When
Column1 = Yes
Column2 = No
Column3 = Yes
Column4 = Yes
Status (Result) = Approved (Conditionally)
AND
When
Column1 = Yes
Column2 = No
Column3 = Yes
Column4 = No
Status (Result) = Rewrok required
Hope that clarifies.
e.g.
When
Column1 = Yes
Column2 = No
Column3 = Yes
Column4 = Yes
Status (Result) = Approved (Conditionally)
AND
When
Column1 = Yes
Column2 = No
Column3 = Yes
Column4 = No
Status (Result) = Rewrok required
Hope that clarifies.