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
ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago
Correct. [Tools] is not blank. The user selected "MVR" and "Service Metrics". The Approver deselected "MVR". So [Tools] now just has "Service Metrics"
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
Can you post your final working formula?