Forum Discussion

ChrisGreen2's avatar
ChrisGreen2
Qrew Member
2 years ago

Using equivalent of SQL IN or CONTAINS for formula

Looking for some Quickbase formula syntax help:  I need this formula to check for multiple RFC Types: Original (checking for one value): ([Project Booking Type]="Proposed" and [Opportunity - RF...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
2 years ago

If I'm understanding right this might work: 

[Project Booking Type]="Proposed" and

(

     [Opportunity - RFC Type] = "Contract Renewal" or

     [Opportunity - RFC Type] = '"Up-Sell/Cross-Sell"

)

If you're doing the opposite where it's not those values: 

[Project Booking Type]="Proposed" and 

[Opportunity - RFC Type] != "Contract Renewal" and

[Opportunity - RFC Type] != '"Up-Sell/Cross-Sell"



------------------------------
Chayce Duncan
------------------------------
  • ChrisGreen2's avatar
    ChrisGreen2
    Qrew Member
    2 years ago

    In the meantime, I think I got it to work like this as well: 

    ([Project Booking Type]="Proposed" and ((Contains(ToText([Opportunity - RFC Type]),"Contract Renewal")) or (Contains(ToText([Opportunity - RFC Type]),"Up-Sell/Cross-Sell"))))


    ([Project Booking Type]="Proposed" and ((not Contains(ToText([Opportunity - RFC Type]),"Contract Renewal")) and (not Contains(ToText([Opportunity - RFC Type]),"Up-Sell/Cross-Sell"))))



    ------------------------------
    Chris Green
    ------------------------------