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
    I'm not sure if you are saying that your problem is solved or not, right now.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    I have it now. Quick Base support found the issue. Thanks.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Can you post your final working formula?