Skip to main content
Question

How can I build this formula in quickbase. Field D and E are arrival and departure dates and I need to filter records within those dates

  • September 27, 2018
  • 0 replies
  • 32 views
I can make this work in excel but don't see the "and" option in QB.

=IF(AND(E7<=(D7-1),E7>=C7),"InHouse","Not InHouse")

My goal is to have a report that only includes in house guests

    This topic has been closed for replies.

    • GauravSharma3
    • Registered
    • September 27, 2018
    Hi Judy,

    Welcome to the community.
    Quick Base has And operator. You can find all Quick Base functions and operators here.

    Try this one. 

    IF(([Your Field Name]<=[Your Field Name])and ([Your Field Name]>=[Your Field Name]),"InHouse","Not InHouse")
    You have to replace your Cell name with the Quick Base field.

    Please let me know if you need any further assistance.

    Thanks,
    Gaurav Sharma
    • JudyJudy
    • Author
    • Registered
    • September 27, 2018
    Thank you for the quick reply!  This worked perfectly.
    Terms & ConditionsAccessibility statement