Formula producing phantom error

  • 1
  • Problem
  • Updated 1 year ago
  • In Progress
Here's my formula:
IF(
  {{Signatures__r.records}}, 
  {{Signatures__r.records.0.Signature_Name__c}} + " (" + FORMAT_DATE( "m/d/yy", {{Signatures__r.records.0.Signature_Date__c}} ) + ")" ,
  ""
)
Here's the error I'm getting on runtime:


The funny thing is, the formula is actually working. It's returning the results I expect. But it's a bad user experience to have an error that isn't really an error.
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb

Posted 1 year ago

  • 1
Photo of Christine Jessen

Christine Jessen

  • 670 Points 500 badge 2x thumb
Hey Matt!

Can you double-check that the formula is correct in the XML itself?  I've run across a similar issue, and ended up finding that the XML itself had invalid syntax, even though the formula itself was evaluating correctly.

Thanks!
Christine