You need to sign in to do that
Don't have an account?
Ross Sutherland
If statement with blanks
Hello,
Trying to create a row level formula that looks to see if any columns has a blank so I have something like,
IF(ISBlank(fHCM2__Team_Member__c.fHCM2__Birth_Date__c),"Blank","Not Blank") which is fine.
But I want to add OR so I want to include OR IF ,
fHCM2__Team_Member__c.fHCM2__Manager__c is blank
OR IF, FK_fHCM2__Employment__c.UDFEmployment_Detail__c is blank
FK_fHCM2__Employment__c.UDFEmployment_Detail__c is a picklist field so not sure how to add that in also.
Any ideas?
Thank
Ross
ISBlank(fHCM2__Team_Member__c.fHCM2__Manager__c),
ISBlank(TEXT(FK_fHCM2__Employment__c.UDFEmployment_Detail__c)) ),"Blank","Not Blank")
All Answers
Hello,
Thanks I get an error - Error when encoding row-level formula: Incorrect parameter type for function 'OR()'. Expected Boolean, received Text
Having said that I have noticed that row level formuals support up to 5 unique fields and I have additional fields to add to the formula,unless there is a workaround?.
Thanks
Ross
Try Below Formula I've Changed Please Mark It As Best Answer If It Helps
Thank You!
Error when encoding row-level formula: Syntax error. Found ')'
Got the above error.
Ross
Error when encoding row-level formula: Formula result is data type (Boolean), incompatible with expected data type (Text).
ISBlank(fHCM2__Team_Member__c.fHCM2__Manager__c),
ISBlank(TEXT(FK_fHCM2__Employment__c.UDFEmployment_Detail__c)) ),"Blank","Not Blank")