I am trying to add two formulas in validation settings but getting syntax errors.
I have created a leave request list in SharePoint. My requirements are below:
If Half Day(Yes/No column) is equal to Yes, then AM or PM(choice column) should be mandatory. If Type Of Leave(Choice column) is equal to Time Off, then Number of Hours(Number Column) should be mandatory.
Need help to put the above two conditions in 1 formula. Sorry I am not a technical person so trying to work around the requirements here.
Also I don’t know how and where to enter code if that’s the solution. I was trying to enter formula. If that’s the solution, it’s the best. So if you can provide a step by step guide.