Skip to main content
Question

Using equivalent of SQL IN or CONTAINS for formula

  • January 31, 2024
  • 0 replies
  • 69 views

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 - RFC Type] ="Contract Renewal")

 

Need (something along these lines to include multiple RFC Types:

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

I'll also need a version of this to check for RFC Types NOT IN the values. 



------------------------------
Chris Green
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • January 31, 2024

    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
    ------------------------------
    Terms & ConditionsAccessibility statement