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
  • 40 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.

    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