Hey Phelan, the Case function is used when checking against a single field. Since you are checking conditions in many fields you'll want to use the If function as Michael suggested.
I'd also consider breaking the logic up into more smaller steps, as it may be easier to debug and maintain. Perhaps you could have a Formula Checkbox for each Phase?
// Phase 1
If (
[nonDHS Program - Manual] = "" and
[Program – HTH] = "" and
[RRH Match] = 0,
true,
// Default to unchecked
false
)
Repeat for the each Phase substituting (not IsNull, IsNull, and, or, etc.) where appropriate. Then, your Phase Formula Text may be more manageable and your reports may be a bit nicer too if you include the Phase checkboxes in sequential order so you can visually scan progress. Anyway, if you take this approach, you'd end up with something like:
// Phase
If (
[Phase 6] = true, "Phase Six",
[Phase 5] = true, "Phase Five",
[Phase 4] = true, "Phase Four",
[Phase 3] = true, "Phase Three",
[Phase 2] = true, "Phase Two",
[Phase 1] = true, "Phase One",
// Default to empty string
""
)
------------------------------
Brian Seymour
------------------------------