Checkbox formula field not working

Question

Why isn't this working?&nbsp; thxIF([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------------------------------

buildpro · Answer

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

buildpro · Answer

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 · Answer

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
------------------------------

Forum Discussion

Checkbox formula field not working

3 Replies