1

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?

1
  • Are you getting any syntax error or the formula logic is not working for you? Jun 22, 2020 at 5:32

1 Answer 1

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.