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...
Forum Discussion
[All Tasks] is a text-multiple choice field...
------------------------------
BuildPro
------------------------------
------------------------------
BuildPro
------------------------------
- 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
------------------------------- 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
------------------------------
