check tow fields values in sharepoint validation settings

Question

I have a form to create a task and the user can edit it after manager approve it, I don't want to allow the user to submit after approval if field [Task Status]="Waiting on someone else" or field [Ext. Due Date] not blank. the user must write Reason for delay in [Reason for the delay] field to submit it if [Task Status]="Waiting on someone else" or field [Ext. Due Date] not blank.

I have tried this formula and it doesn't work for me:

=OR(([Task Status]="Waiting on someone else",(NOT(ISBLANK([Ext. Due Date])))),IF([Reason for the delay]<>"",TRUE,FALSE),TRUE)

Any help?

Answer 1

Try using below formula:

=IF(OR([Task Status]="Waiting on someone else",NOT(ISBLANK([Ext. Due Date]))), IF([Reason for the delay]="",FALSE,TRUE), TRUE)

Note:

1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

Official Documentations:

1. Calculated Field Formulas.
2. IF function.