function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ross SutherlandRoss 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
 

Best Answer chosen by Ross Sutherland
CharuDuttCharuDutt
IF(IOR( ISBlank(fHCM2__Team_Member__c.fHCM2__Birth_Date__c),
ISBlank(fHCM2__Team_Member__c.fHCM2__Manager__c),
ISBlank(TEXT(FK_fHCM2__Employment__c.UDFEmployment_Detail__c)) ),"Blank","Not Blank")

All Answers

Ross SutherlandRoss Sutherland

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

CharuDuttCharuDutt
Hii Ross
Try Below Formula I've Changed
OR(
ISBlank(fHCM2__Team_Member__c.fHCM2__Birth_Date__c),
ISBlank(fHCM2__Team_Member__c.fHCM2__Manager__c), 
ISBlank(TEXT(FK_fHCM2__Employment__c.UDFEmployment_Detail__c)),
)
Please Mark It As Best Answer If It Helps
Thank You!
Ross SutherlandRoss Sutherland
Warning
Error when encoding row-level formula: Syntax error. Found ')'


Got the above error.
Ross
Ross SutherlandRoss Sutherland
got this now

Error when encoding row-level formula: Formula result is data type (Boolean), incompatible with expected data type (Text).
CharuDuttCharuDutt
IF(IOR( ISBlank(fHCM2__Team_Member__c.fHCM2__Birth_Date__c),
ISBlank(fHCM2__Team_Member__c.fHCM2__Manager__c),
ISBlank(TEXT(FK_fHCM2__Employment__c.UDFEmployment_Detail__c)) ),"Blank","Not Blank")
This was selected as the best answer
Ross SutherlandRoss Sutherland
Thanks very much. Ross
Ross SutherlandRoss Sutherland
*Replce IOR with OR