Ask Search:
Barbara ArthurBarbara Arthur 

Error: Field Touch_Frequency_PW__c may not be used in this type of formula

I get an error message:  Error: Field Touch_Frequency_PW__c may not be used in this type of formula.  Touch Frequency is a Picklist Field and Last Review is a date field.  Any suggestions/corrections for the following formula calculation?   
 
IF (ISPICKVAL(Touch_Frequency_PW__c  , "Annual"),  Last_Review_PW__c   + 365,
IF (ISPICKVAL(Touch_Frequency_PW__c , "Semi-Annual"), Last_Review_PW__c  + 180,
IF (ISPICKVAL(Touch_Frequency_PW__c , "Quarterly"), Last_Review_PW__c  + 90, Last_Review_PW__c
)
)

)

thank you for your help!
Barbara
Best Answer chosen by Barbara Arthur
Taha SyedTaha Syed
Or just start from the beginning.. Create a custom field of type "Formula"
Select return type as "Date"
Then enter this formula..
It should work.

All Answers

Taha SyedTaha Syed
May I know if this is a formula field of data type Date that you are trying to populate
 
Barbara ArthurBarbara Arthur
Hello Taha,
Yes, the field I am trying to populate is a Date field.
Sunil SarillaSunil Sarilla
Hi Barbara,
What is the data tupe of Touch Frequency PW field?
Barbara ArthurBarbara Arthur
Hi Sunil,
The Touch Frequency field is a picklist with only those three values (Quarterly, Semi-annual, Annual)
Sunil SarillaSunil Sarilla
Where and how are you using this formula, i.e. field update formula, direct formula field?
Taha SyedTaha Syed
Just recreated the same on a formula field (return type date) on opportunity.. works perfectly with no syntax errors..
 
IF ( ISPICKVAL(StageName , "Annual"),
    Billing_Date__c + 365,
    IF ( ISPICKVAL(StageName, "Semi-Annual"),
            Billing_Date__c + 180,
            IF (ISPICKVAL(StageName, "Quarterly"),
                Billing_Date__c + 90,
                Billing_Date__c
                )
        )
    )

I think you should check the data types of your fields.
StageName is Picklist
Billing_Date__c is Date field


 
Barbara ArthurBarbara Arthur
I am trying to insert the formula directly on the custom field created in the CONTACTS object, which may be causing the problem.  The formula field has a drop down called "Select Field Type" but doesn't seem to give an option for the CONTACT object.

 
Barbara ArthurBarbara Arthur
Hi Sunil, Here is a screen shot: [cid:image001.jpg@01D3BAEE.FC3152B0] Click here to send a secured file Barbara H. Arthur The Actuarial Consulting Group 1640 Huguenot Road Midlothian, Virginia 23113-2427 Phone: (804) 323-1886 Fax: (804) 323-1889 E-Mail: barthur@acgworldwide.com World Wide Web: www.acgworldwide.com [cid:image002.png@01D30145.A61DAC10] The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, please notify us immediately by e-mail, and delete the original message without any review/dissemination thereof. Please remember to contact the sender at ACG Advisory Services, Inc. or Actuarial Consulting Group, Inc., in writing, if you have questions pertaining to any services being provided or if there are any changes in your personal/financial situation or investment objectives for the purpose of reviewing/evaluating/revising our previous recommendations and/or services, or if you want to impose, add to, or modify any reasonable restrictions to any investment advisory services being provided, or if you wish to direct either company mentioned above to effect any action, including any specific transactions for your account. Please be advised that there can be no assurance that any email request will be reviewed and/or acted upon on the day it is received - please be guided accordingly. A copy of our current written disclosure statement discussing our advisory services and fees continues to remain available for your review upon request.
Barbara ArthurBarbara Arthur
Oh my goodness......just finally understood your question.  I chose DATE as the field type instead of Formula as the field type when initially creating the calculated Field.   Thank you so much for helping me see the light!!!!  :-)
Taha SyedTaha Syed
In that dropown you have to select date. Thats the forumla return type.
 
Taha SyedTaha Syed
Or just start from the beginning.. Create a custom field of type "Formula"
Select return type as "Date"
Then enter this formula..
It should work.
This was selected as the best answer
Taha SyedTaha Syed
That solves our problem =)
Barbara ArthurBarbara Arthur
Thank you for your help!