Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
3 years ago

Formula checkbox not working for more than one parameter

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-Per...
ChayceDuncan's avatar
ChayceDuncan
Qrew Captain
3 years ago

From a quick glance you're using & instead of 'and'. 'and' syntax is how Quickbase will combine conditions, where as & 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]<Days(30)
and Contains([All Session Modalities Next Session Date NOT CANCELLED or DOWNSIZED],"In-Person"), 
true)



------------------------------
Chayce Duncan
------------------------------
DawnRene3's avatar
DawnRene3
Qrew Trainee
3 years ago

Boom! That was it! Thank you!



------------------------------
Dawn Rene
------------------------------