Skip to main content
Question

Formula error: Expecting text but found number in numeric reference formula field

  • May 13, 2019
  • 0 replies
  • 88 views
I have a numeric reference field with the following formula:

[Pharmacy / Drug Shipping - Record ID#]

And I'm receiving an error with the entire formula underlined in red stating "Expecting text but found number".  The number is correct; why is it expecting text?
    This topic has been closed for replies.

    Is your field type formula-numeric? Sounds like the error you would receive if the formula you have is text? Does wrapping it in a toText() resolve it?

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    If the formula does save OK  and you are just referring to the yellow triangle warning in the formula editor, sometimes that formula editor is not 100% correct in its warnings, ie it may be a false alarm.


    Terms & ConditionsAccessibility statement