Discussions

 View Only
Expand all | Collapse all

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

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

    Posted 09-27-2018 04:20
    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



  • 2.  RE: 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

    Posted 09-27-2018 04:29
    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


  • 3.  RE: 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

    Posted 09-27-2018 05:23
    Thank you for the quick reply!  This worked perfectly.


  • 4.  RE: 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

    Posted 09-27-2018 05:52
    Awesome. Please feel free to reach out to us if you need any kind of help.

    Thanks,
    Gaurav