If formula not working

  • 1
  • Problem
  • Updated 2 years ago
  • Solved
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")
Photo of Brayden Smith

Brayden Smith

  • 1,078 Points 1k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
I 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")
(Edited)
Photo of Brayden Smith

Brayden Smith

  • 1,078 Points 1k badge 2x thumb
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.