I have the following if formula references a reference field. It shows blank on all rows:
IF({{Primary_Vendor_Contact__c}} != null, "No error" , "A primary contact is not designated for this relationship")
Solved
If formula not working
+8Best answer by Brayden_Smith
My issue was, I had a UI Only field on a model that was adopting rows from another model, without querying the model, so formula fields weren’t calculating.
+13I think you could remove the != null and it should work.
IF({{Primary_Vendor_Contact__c}},“No error”,“A primary contact is not designated for this relationship”)
+8My issue was, I had a UI Only field on a model that was adopting rows from another model, without querying the model, so formula fields weren’t calculating.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.