Skip to main content
Question

If Statment Clarification

  • September 28, 2018
  • 0 replies
  • 33 views
HI There I have an if statment in my formula that I need to try an make a little more precise.  I currently have the following:

If(
[Port of Loading]="Vancouver", [Voyage Dates - Documentation cut off3],
)

I need to add another field to help drill this down a bit more - want to add the below into the above.  

[Place of Receipt]="Calgary", [Voyage Dates - Calgary Documention Cut off],

Essentially, if [Port of Loading] and [place of receipt] both equal these specified values, this field should show a value that I specify.  Sorry i'm not sure how to explain it well, hope this make sense.




    This topic has been closed for replies.

    • ChrisChris
    • Quickbase Alumni
    • September 28, 2018
    When you say it should have a value you specify if both conditions are true, do you mean a value you enter? You cannot manually enter a value into a formula field.





    • olivermah
    • Author
    • Quickbase Alumni
    • September 28, 2018
    Sorry not a value but a field that I specify - wrong choice of words:  I need something like this:

    If Field y = Y and Field X = X, show Field Z
    • ChrisChris
    • Quickbase Alumni
    • September 28, 2018


    Would this be what you mean?

    if(
    [Port of Loading]="Vancouver" and [Place of Receipt]="Calgary", [FIELD Z],
    If(
    [Port of Loading]="Vancouver" and [Place of Receipt]<>"Calgary", [Voyage Dates - Documentation cut off3],
    If(
    [Place of Receipt]="Calgary" and [Port of Loading]<>"Vancouver",[Voyage Dates - Calgary Documentation Cut off]
    )))



    • olivermah
    • Author
    • Quickbase Alumni
    • September 28, 2018
    I think so....What does the <> mean when you replace the =
    Terms & ConditionsAccessibility statement