You need to sign in to do that
Don't have an account?
![jtretakoff jtretakoff](https://dfc-org-production.my.site.com/img/userprofile/default_profile_45_v2.png)
Basic question...baffled
Hi, I know this is probably one of the most basic questions, but I've scoured this board and the online help, and I'm at a loss.
I have created a custom field in my Opportunity, called LiveDate. I want to create a second filed that calculates LiveDate + 6 months.
The field name is LiveDate; the API field is LiveDate__c. When I do the formula:
LiveDate + 180
Or
LiveDate__c + 180
I get the following message:
Error: Field LiveDate__c does not exist. Check spelling.
Help? What basic thing have I overlooked?
I have created a custom field in my Opportunity, called LiveDate. I want to create a second filed that calculates LiveDate + 6 months.
The field name is LiveDate; the API field is LiveDate__c. When I do the formula:
LiveDate + 180
Or
LiveDate__c + 180
I get the following message:
Error: Field LiveDate__c does not exist. Check spelling.
Help? What basic thing have I overlooked?
$Organization
$System
$User
$User Role
None of the subsequent merge fields show my LiveDate field.
I appreciate the help...
1) Created a Custom field in Opportunity, called LiveDate. It's a type of Date.
2) In the General Options for the Custom Field, I click on Formula Editor.
3) The only Field Types that are displayed are as I described.
I see no Advanced tab. Am I just missing it?
There's a little confusion in this thread... You're trying to write a formula for a default value in a standard field. NPM provided some good feedback here, but applicable a standard formula field rather than a default value formula. Default value formulas are different. A default value formula can't use field values from the record, because the record is new and hasn't been saved yet with a value in the field. Therefore, Salesforce prevents you from using fields from the same object in a default value formula. That is why you don't see your field in the dropdown list, and that is why you get a "field doesn't exist" error when you try manually typing in the field API name.
To get what you need (a calculation of a date from another field + 6 months), you will need to use a formula that calculates AFTER the record is saved. Use a standard formula field if you don't want/need this date to ever be edited, or use a workflow rule and field update if you just want to put a default value in a field that may/can be updated later.