I'm trying to figure out how to add two validation rules to One SharePoint list.
- If the user selects 'Risk' from the 'Risk/Issue?' column, then they must not leave the 'Risk Mitigation Plan' field blank.
'Risk/Issue?' Column is a drop down menu, Risk Mitigation Plan is a multiple line text field
- If the user selects 'Closed' from the 'Status' column then the must not leave the 'Closed Date' field blank
The 'Status' field is a drop down menu and the 'Closed Date' field is a date picker
What formula would help me accomplish this? Thank you!
--I can change the field types if that helps
Screen shot of the list & validation I'm trying to Implement