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
I will do some of your formula for you. This would be a formula check box field type. You would need to create a separate field to calculate a message based on this checkbox.
It's a lot of typing and I'm not that fast :)
Note that Quick Base quote always look like this " and not the curly kind in your post. Just in case I missed any
Your logic statement was basically just a RunOnSentenceWithVery LittlePunctuation, so I'm kinda guessing how the ANDs and ORs and brackets should go.
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"
or
[Level 2 TWU Decision] = "Labor Summary")
)
and
Contains([Settlement Note", "Pay")
and
[Amount Paid Out] =0,
true)
if there is a syntax error in the above that you cannot figure out, be sure to copy and paste post your exact formula and the complete error message (ie not a screen shot, but a copy and paste).
It's a lot of typing and I'm not that fast :)
Note that Quick Base quote always look like this " and not the curly kind in your post. Just in case I missed any
Your logic statement was basically just a RunOnSentenceWithVery LittlePunctuation, so I'm kinda guessing how the ANDs and ORs and brackets should go.
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"
or
[Level 2 TWU Decision] = "Labor Summary")
)
and
Contains([Settlement Note", "Pay")
and
[Amount Paid Out] =0,
true)
if there is a syntax error in the above that you cannot figure out, be sure to copy and paste post your exact formula and the complete error message (ie not a screen shot, but a copy and paste).