I have a SharePoint 2013 list where I need to log Issues.
One of my column is labelled "Issue Status". Generally, I have REQUIRED field populated when the form is filed out and the "Issue Status" = OPEN or = PENDING.
But I want to make some columns REQUIRED and others OPTIONAL when someone selects "Issue Status" = DRAFT.
Can this is done by Validation Setting in SharePoint? If so, what is the formula?
For example: IF "Issue Status" = DRAFT then "Control ID" and "Impacted Business" Column is OPTIONAL and the rest is REQUIRED.
All I want is when someone logs an issue as a draft they have a freedom not to fill all the required columns. For example, when an issue is saved as a draft they will fill only TWO of the required column but if the issue is set to "Open" they will fill ALL the required column