Forum Discussion

BobbyHollis's avatar
BobbyHollis
Qrew Member
5 years ago

Simple If & OR Ain't So Easy For Me !

Howdy! New user here getting better every day! I just found this community and glad to see so many helpful people! 

I need a field that returns a "YES" if one of two other fields meet certain criteria. One of the fields is a Text (lookup)  type, the other is a Text - Multiple Choice type. Seems important to say that because I have seen comments about how multiple-choice fields are not conducive to isnull statements, and I have tried the 'trim' trick seen posted to no avail. 

My goal for this field, that is referencing these other two fields, is if the Text (lookup) field contains [CERTAIN TEXT] OR if my Text - Multiple Choice has literally anything in it (not null), then my field delivers a "YES". Otherwise, I would like it to remain blank. 

The Text (lookup) field = [Partner - Name]
The Text - Multiple Choice = [Status]

This is what I have tried: 

IF([Partner - Name]="Funding Circle" OR if(isnull([Status]), "Pending", "Complete")
If([Partner - Name]="Funding Circle" OR [Status]=null,"YES","") 
If([Partner - Name]="Funding Circle" OR If (Trim([Status])="","YES","")

Is this possible?  Go easy on me - I'm anything but dev-minded but love a good puzzle

------------------------------
Bobby Hollis
------------------------------
Formulas and functions

3 Replies

Sort By
  • BabiPanjikar's avatar
    BabiPanjikar
    Qrew Assistant Captain
    5 years ago
    Bobby,

    Try this one.

    IF( ToText([Partner - Name])="Funding Circle" OR Length([Status])<1, "Pending", "Complete")


    ------------------------------
    Babi Panjikar
    ------------------------------
    • BobbyHollis's avatar
      BobbyHollis
      Qrew Member
      5 years ago
      that did it! Only one thing I had to adjust, the carrot <1 -> >1

      THANK YOU !! 
      Bh

      ------------------------------
      Bobby Hollis
      ------------------------------
      • BabiPanjikar's avatar
        BabiPanjikar
        Qrew Assistant Captain
        5 years ago
        Great to hear that.

        ------------------------------
        Babi Panjikar
        ------------------------------