Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

Formula checkbox needs to uncheck when conditions change

I have a formula checkbox that says      If(([Related Department or Group] = 13) and Contains(ToText([Tools]), "MVR") true,false) This works fine until [Tools] changes from "MVR" to "" What ha...
App builders
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Try this

[Related Department or Group] = 13
and ToText([Tools])<>""
and Contains(ToText([Tools]), "MVR") 

I'm testing [Tools] is not blank and also just using less code as the If is not really needed for a boolean.