Forum Discussion
BuildPro
3 years agoQrew Captain
[All Tasks] is a text-multiple choice field...
------------------------------
BuildPro
------------------------------
------------------------------
BuildPro
------------------------------
- BuildPro3 years agoQrew CaptainThis 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
------------------------------- MikeTamoush3 years agoQrew CommanderThe 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
------------------------------