Discussions

 View Only
  • 1.  Checkbox formula field not working

    Posted 05-11-2022 11:50
    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
    ------------------------------


  • 2.  RE: Checkbox formula field not working

    Posted 05-11-2022 11:56
    [All Tasks] is a text-multiple choice field...

    ------------------------------
    BuildPro
    ------------------------------



  • 3.  RE: Checkbox formula field not working

    Posted 05-11-2022 12:27
    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
    ------------------------------



  • 4.  RE: Checkbox formula field not working

    Posted 05-11-2022 15:02
    Edited by Mike Tamoush 05-11-2022 15:03
    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
    ------------------------------