Formula checkbox not working for more than one parameter

Question

I have a formula checkbox that doesn't seem to work when adding more than one condition. I want it to be true when a duration field is less than 30 days and another multi-select text contains "In-Person".
My formula is:
If([Duration-Delivered - Created]&lt;Days(30)&amp; Contains([All Session Modalities Next Session Date NOT CANCELLED or DOWNSIZED],"In-Person"),&nbsp;true)
The first one by itself works fine, If([Duration-Delivered - Created]&lt;Days(30), true). However, when I add the second part the &lt; highlights yellow and says the less than sign cannot be applied on types duration, text.
Any assistance would be appreciated.------------------------------Dawn Rene------------------------------

dawnrene3 · Answer

Boom! That was it! Thank you!
------------------------------Dawn Rene------------------------------

chayceduncan · Answer

From a quick glance you're using &amp; instead of 'and'. 'and' syntax is how Quickbase will combine conditions, where as &amp; is how you combine text values. Same thing goes for 'or'. If you update your formula as follows you should be good.

If([Duration-Delivered - Created]&lt;Days(30)and Contains([All Session Modalities Next Session Date NOT CANCELLED or DOWNSIZED],"In-Person"),&nbsp;true)------------------------------Chayce Duncan------------------------------

Forum Discussion

Formula checkbox not working for more than one parameter