Forum Discussion

GabriellaTremog's avatar
GabriellaTremog
Qrew Member
3 years ago

IF Formula Help

Hello - hoping someone can provide some assistance. 

I'm trying to create a formula field that gives a Yes/No output based on the answer of two other fields. 

If [daytime]=no AND [evening]=no, then my [formula field]=no
However, if [daytime]=yes OR [evening]=yes, then my [formula field]=yes

Does anyone have any ideas? Thank you in advance!

------------------------------
Gabriella Tremoglie
------------------------------
Formulas and functions

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    try this
    IF(
    [daytime]="no" AND [evening]="no", "no",
    [daytime]="yes" OR [evening]="yes", "yes")

    Note that if either of the two fields, [daytime] or [evening] are blank than this formula will result in blank.  

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • GabriellaTremog's avatar
      GabriellaTremog
      Qrew Member
      3 years ago
      Thanks Mark. Neither of the fields are blank, but this formula is still resulting in blank. 

      If(
      [Daytime]="no" and [Evening]="no", "no",
      [Daytime]="yes" or [Evening]="yes", "yes")

      I should note that both my [daytime] and [evening] fields are already formula-text fields. Not sure if that makes a difference.,

      ------------------------------
      Gabriella Tremoglie
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago
        The test on equals =  is case sensitive. 
        Can you check the Capitalization of your fields.  Are they for example Yes or YES where our formula is testing for yes.

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------