Formula producing phantom error

  • 1
  • Problem
  • Updated 2 years ago
  • In Progress
Here's my formula:
  {{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

  • 32,410 Points 20k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Christine Jessen

Christine Jessen, Alum

  • 690 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.