Referencing multiple field for a formula
I?m trying to get a formula checkbox or text field with a message message to display when a condition isn?t met. I don?t know if what I want is not possible of I just can?t figure out how to input ...
Forum Discussion
Thanks for your help. I am receiving a Formula syntax error that i have below.
A closing parenthesis is missing.
If(
([grievance type]="Overtime Bypass" or [grievance type]="Mandatory Overtime" or [grievance type]="Payroll" or [grievance type]="Termination")
and (
([level 1 Company Decision]="Accept" and [Level 1 IAM Decision] ="Accept") or ([level 1 Company Decision]="Accept" and [Level 1 TWU Decision]="Accept") or ([level 2 Company Decision]="Accept� and [Level 2 TWU decision] =" Accept"))
and Contains([Labor Summary or Settlement Note], "Pay") and [Amount Paid Out]=0, true)
A closing parenthesis is missing.
If(
([grievance type]="Overtime Bypass" or [grievance type]="Mandatory Overtime" or [grievance type]="Payroll" or [grievance type]="Termination")
and (
([level 1 Company Decision]="Accept" and [Level 1 IAM Decision] ="Accept") or ([level 1 Company Decision]="Accept" and [Level 1 TWU Decision]="Accept") or ([level 2 Company Decision]="Accept� and [Level 2 TWU decision] =" Accept"))
and Contains([Labor Summary or Settlement Note], "Pay") and [Amount Paid Out]=0, true)
- It was actually one of the curly quotes acting up, just as Mark predicted
This should work
If(
([grievance type]="Overtime Bypass" or [grievance type]="Mandatory Overtime" or [grievance type]="Payroll" or [grievance type]="Termination")
and (
([level 1 Company Decision]="Accept" and [Level 1 IAM Decision] ="Accept") or
([level 1 Company Decision]="Accept" and [Level 1 TWU Decision]="Accept") or
([level 2 Company Decision]="Accept" and [Level 2 TWU decision] ="Accept")
)
and Contains([Labor Summary or Settlement Note], "Pay") and [Amount Paid Out]=0, true) - Thanks for your help. Its working now
