Skip to main content
Topics#Data ManagementWendy Congleton's Question
Wendy Congleton (Colorado Department of Education) asked in #Data Management
Dec 23, 2016, 6:16 PM

Formula field error: Expected Number, Date, DateTime, Picklist, received Text

I originally created a date field on the contact and was pulling it through to the opporutnity object with a formula and all was good. 

 

I had to change the contact field type to text.  I then tried to change the formula field on the EO to a text type and I keep getting the error:  "Expected Number, Date, DateTime, Picklist, received Text"

 

I even deleted the formula field and started over with it as a text field to start and it still gives the error. 

 

The formula is super simple and I have used this format many times with success:  

 

Text( EnrollmentrxRx__Applicant__r.Callback_Date__c )

 

Any suggestions. 

 

 
3 answers
  1. Akhil Anil (Intigris)
    Dec 23, 2016, 6:31 PM
    Hi Wendy,

     

    It looks like Callback Date is already a text field ?

     

    Did you try this without a TEXT() ?

     

     

    EnrollmentrxRx__Applicant__r.Callback_Date__c

     

     
Write an answer...
0/9000