Wow that was one crazy bug. It wants the and in lower case! It never used to be that way, like in the last 20 years! I also noticed that when you use the formula query the AND has to be in upper case. I have a feeling that the introduction of the formula query function confused Quickbase.
Try this
IF(
[Service Type Authorization Description] = "Agency Hired Respite", "Empower U. Services Corp",
[Service Type Authorization Description] = "Intensive In-Home Clinical - Licensed Level" and [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC",
[Service Type Authorization Description] = "Intensive In-Home Clinical - Masters Level" and [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC")
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------