Discussions

Expand all | Collapse all

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

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

    Posted 17 days ago
    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
    ------------------------------


  • 2.  RE: Simple If & OR Ain't So Easy For Me !

    Posted 17 days ago
    Bobby,

    Try this one.

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


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



  • 3.  RE: Simple If & OR Ain't So Easy For Me !

    Posted 17 days ago
    that did it! Only one thing I had to adjust, the carrot <1 -> >1

    THANK YOU !! 
    Bh


    ------------------------------
    Bobby Hollis
    ------------------------------



  • 4.  RE: Simple If & OR Ain't So Easy For Me !

    Posted 17 days ago
    Great to hear that.

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