You need to sign in to do that
Don't have an account?
Jaye Lowe
ISBLANK and Record type
Hey, all I am looking to have a formula field that looks at Record ID and then checks to see if the picklist field level of care is blank and if it is blank than to return a null value in the field. Here is my code.
IF(
AND(
RecordType.Id = "012j0000000poaT",
TEXT( Level_of_Care__c ) =""
), NULL,
It doesn't seem to be working. Any help would be greatly appreciated. Thanks!
IF(
AND(
RecordType.Id = "012j0000000poaT",
TEXT( Level_of_Care__c ) =""
), NULL,
It doesn't seem to be working. Any help would be greatly appreciated. Thanks!
I think you are not passing the false criteria for if condition.
I tried to replicate the scenarion in my dev org and it seems working.
If it helps, Please mark it as best answer.
Thanks!
All Answers
I think you are not passing the false criteria for if condition.
I tried to replicate the scenarion in my dev org and it seems working.
If it helps, Please mark it as best answer.
Thanks!
try this I think It should work
IF()'. Expected 3, received 4
Please align you formula as per above syntax. I would suggest add condition one by one and then check syntax followed by adding next condition.
Try to follow above alignment to avoid confusion of closing the bracket
What adat type of formula field you using , after that i can suggest
F(
AND(
RecordType.Id = "0123a00000117x3",
TEXT( Level_of_Care__c ) = "IOP"
), 0.5/2,
IF(
AND(
RecordType.Id = "012f10000004ZDm",
TEXT( Level_of_Care__c ) = "IOP"
), 0.5/2,
IF(
AND(
RecordType.Id = "0123a00000117x8",
TEXT( Level_of_Care__c ) = "IOP"
), 1.5/2,
IF(
AND(
RecordType.Id = "012j0000000poaT",
TEXT( Level_of_Care__c ) = "IOP"
), 1.5/2,
IF(
AND(
RecordType.Id = "012j0000000poaT",
TEXT( Level_of_Care__c ) <> ""
), 1.5,
IF(
AND(
RecordType.Id = "0123a00000117x8",
TEXT( Level_of_Care__c ) <> ""
), 1.5,
IF(
AND(
RecordType.Id = "012f10000004ZDm",
TEXT( Level_of_Care__c ) <> ""
), 0.5,
IF(
AND(
RecordType.Id = "0123a00000117x3",
TEXT( Level_of_Care__c ) <> ""
), 0.5, NULL))))))))
Thanks!