Discussions

 View Only
  • 1.  Checkbox formula field not working

    Posted 14 days ago
    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 14 days ago
    [All Tasks] is a text-multiple choice field...

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



  • 3.  RE: Checkbox formula field not working

    Posted 14 days ago
    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 14 days ago
    Edited by Mike Tamoush 14 days ago
    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
    ------------------------------