Forum Discussion

JudyJudy's avatar
JudyJudy
Qrew Trainee
6 years ago

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

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

Formulas and functions

3 Replies

Sort By
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    6 years ago
    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's avatar
    JudyJudy
    Qrew Trainee
    6 years ago
    Thank you for the quick reply!  This worked perfectly.
    • GauravSharma3's avatar
      GauravSharma3
      Qrew Commander
      6 years ago
      Awesome. Please feel free to reach out to us if you need any kind of help.

      Thanks,
      Gaurav