Salesforce edition: professional edition
No Developer resources.
 
For any given opportunity, we have the following fields filled out:
 
Fee Estimate: 700,000
Production Estimate: 3,800,000
Projected Project Debut Date: 2/1/2016
Projected Project Completion Date: 10/1/2017
 
Revenue forecasting formula shown below, allocates revenue per year.
 
Currently in SF, this formula field is accurately calculating “2016 Fee Estimate”:
 
IF( Projected_Debut_Date__c > End_of_2016__c ,0, 
IF( Projected_Completion_Date__c < End_of_2015__c ,0,( 
IF( Projected_Completion_Date__c > End_of_2016__c, End_of_2016__c,Projected_Completion_Date__c) - 

IF( Projected_Debut_Date__c<End_of_2015__c,End_of_2015__c,Projected_Debut_Date__c)) / 

(Projected_Completion_Date__c - Projected_Debut_Date__c) * Fee_Estimate__c ))
 
The problem with the above formula is that it is specific to the year 2016. The field “2016 Fee Estimate” will become obsolete after 2016.
 
I need to find a way to create generic fields, whereby “Year 0” represents the current year. Every subsequent year, year 0 represents the actual current year. (This eludes to the fact that a reference date field (Year 0) will change every year to reflect the right year)
 
Ideal situation:
 
Year 0 Fee Amount: value
Year 0 Production Amount: value
 
Year 1 Fee Amount: value
Year 1 Production Amount: value
 
Year 2 Fee Amount: value
Year 2 Production Amount: value
 
Any suggestions on how this can be done? thank you in advance!!
 

In an opportunity, I have the following picklist values for opportunity stage:
"Unqualified"
"Qualified - Undefined Scope"
"Qualified - Defined Scope"

There is a field titled " Fee Estimate", which is currently set to not required.
If the values of only "Qualified - Undefined Scope" and "Qualified - Defined Scope" are selected, how can there be a validation rule that requires a user to fill out the field "Fee Estimate".

ie. the field "Fee Estimate" has to be filled in everytime the opportunity stage is either Qualified - Undefined Scope"
"Qualified - Defined Scope". It is not required for "Unqualified".

Can someone please help in guiding me where to start?

Thank you in advance!

In an opportunity, I have the following picklist values for opportunity stage:
"Unqualified"
"Qualified - Undefined Scope"
"Qualified - Defined Scope"

There is a field titled " Fee Estimate", which is currently set to not required.
If the values of only "Qualified - Undefined Scope" and "Qualified - Defined Scope" are selected, how can there be a validation rule that requires a user to fill out the field "Fee Estimate".

ie. the field "Fee Estimate" has to be filled in everytime the opportunity stage is either Qualified - Undefined Scope"
"Qualified - Defined Scope". It is not required for "Unqualified".

Can someone please help in guiding me where to start?

Thank you in advance!