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
------------------------------