Create a formula that shows where an Opportunity is in the pipeline.

Create a formula field that classifies an Opportunity as either “Early”, “Middle”, or “Late”. This formula field should use TODAY() to calculate what percentage of the time between an opportunity’s CreatedDate and CloseDate has passed, and label the opportunity accordingly.

• This formula should be on the Opportunity object
• This formula should be named 'Opportunity Progress' with the resulting API name Opportunity_Progress__c
• This formula should return 'Early' if less than or equal to 25% of an opportunity has passed
• This formula should return 'Middle' if between 25% and 75% of an opportunity has passed
• This formula should return 'Late' if more than 75% of an opportunity has passed
• This formula should reference a helper formula field, also on the Opportunity Object, with the type Percent and the name Percent Completed
• Percent Completed should return the percentage of the time that has passed between an opportunity’s CreatedDate and CloseDate.

1) Create one custom 'Percent Completed' helper formula field on opportunity object of type percent and enter the below formula.

(TODAY() - DATEVALUE(CreatedDate))/(CloseDate - DATEVALUE(CreatedDate))

2) Create one custom 'Opportunity Progress' formula field on opportunity object of type text and enter the below formula.

IF( Percent_Completed__c <=25,"Early", 

IF(Percent_Completed__c <=75,"Middle", 

"Late"))