I need to add a column validation to my list.
The requirement for the validation is that the column [Body] cant be empty if the column [Status] is one of this statuses: "1-Cancelled" or "2-Awaiting Information from Requester".
I tested the below formula in Excel which is working, but not working in the SharePoint.
=NOT( AND( OR( [Status]="1-Cancelled",[Status]="2-Awaiting Information from Requester"), ISBLANK([Body]) ))
Please help me to find the right formula. Thanks in advance