Can i benefit from List validation to force fields to be conditionally mandatory

Steel Contributor

I have a custom list inside sharepoint on-premises 2013, which have these fields:-

1. Status. drop-down(Open,Closed).

2. Type. drop-down(item,Box).

3. Comment. Multiple line of text (allow pictures and tables).

4. Actions. Multiple line of text (allow pictures and tables).

5. Detailed Description. Multiple line of text (allow pictures and tables).

 

now i want to set this validation:-

1. if the Status is set to Closed, then the user must enter values inside the Comment.

2. if the Status is set to Closed and the Type = Box, then in-addition to the above case, the user must enter text inside the Actions and Detailed Description fields.

 

so i am not sure if i can benefit from the list validation to perform the above 2 validations?

 

 

1 Reply
I think you need scripting to achieve conditional requirements in Sharepoint. Maybe PowerApps has the feature you're looking for but I don't know much about that and since you're using 2013, hence classic layout, I believe scripting would be the easiest approach. Lemme know if you need help on that.

Regards