Formula Fields
I am in need of a formula with a few conditions. See criteria below
If [Service Type Authorization Description] = 'Agency Hired', then [Providing Agency] = "Airplane Services", [Provider ID #] =...
Forum Discussion
------------------------------
Del
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendDel would you please copy and paste the code into the thread here and I will try it in my own app?
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
- MarkShnier__You.. also please confirm that the field type is formula text.
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------- MarkShnier__YouI tried the code here and it worked.
IF(
[Service Type Authorization Description] = "Agency Hired Respite", "Empower U. Services Corp",
[Service Type Authorization Description] = "Intensive In-Home Clinical" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC",
[Service Type Authorization Description] = "Intensive In-Home Clinical" AND [Authorization - Responsible Payer] = "Medicaid", "Clinical Care LLC")
------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------- Yes it is formula Text, still giving me that error
------------------------------
Del
------------------------------