Forum Discussion

JudyJudy's avatar
JudyJudy
Qrew Trainee
7 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
GauravSharma3's avatar
GauravSharma3
Qrew Commander
7 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