Forum Discussion

Qrew Member

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

Qrew Captain

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

Qrew Member

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