Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
3 years ago

Checkbox formula field not working

Why isn't this working?  thx
IF(
[All Tasks]="04.Hang"=true,true,
[All Tasks]="06.Scrap"=true,true,
[All Tasks]="08.Finish"=true,true,
[All Tasks]="09.Finish.Gar Tape"=true,true,
[All Tasks]="10.Sand"=true,true,
[All Tasks]="12.PT/UP"=true,true,
[All Tasks]="17.Coffered Hang"=true,true,
[All Tasks]="18.Coffered Finish"=true,true,
[All Tasks]="19.Coffered Sand"=true,
true,false)

------------------------------
BuildPro
------------------------------
  • [All Tasks] is a text-multiple choice field...

    ------------------------------
    BuildPro
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      This works now...

      Case([Task Name],
      "04.Hang",true,
      "06.Scrap",true,
      "08.Finish",true,
      "09.Finish.Gar Tape",true,
      "10.Sand",true,
      "12.PT/UP",true,
      "17.Coffered Hang",true,
      "18.Coffered Finish",true,
      "19.Coffered Sand",true)

      ------------------------------
      BuildPro
      ------------------------------
      • MikeTamoush's avatar
        MikeTamoush
        Qrew Commander
        The Case function is perfect to use for your case. But just so you know, the original would have needed to look like this:

        IF(
        [All Tasks]="04.Hang",true,
        [All Tasks]="06.Scrap",true,
        [All Tasks]="08.Finish",true,
        [All Tasks]="09.Finish.Gar Tape",true,
        .....,false)

        Alternately, with formula check box fields, you can simply give it the conditions that make it true, without even an if formula.

        [All Tasks]="04.Hang" or
        [All Tasks]="06.Scrap" or
        [All Tasks]="08.Finish" or
        [All Tasks]="09.Finish.Gar Tape", or
        .....

        ------------------------------
        Mike Tamoush
        ------------------------------