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:
Is this possible? Go easy on me - I'm anything but dev-minded but love a good puzzle
------------------------------
Bobby Hollis
------------------------------
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 [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
------------------------------
