Loading

Stage duration field that shows days an Opportunity has rested in current Stage

Дата публикации: Jul 22, 2025
Описание
The Related List "Stage History" only shows the date that an Opportunity was moved to a particular stage. This field will show how long an Opportunity has rested in its current stage.
Решение
Step 1: From Setup, at the top of the page, select Object Manager. Under Quick Find look for the Opportunity object. 

0009.PNG


0010.PNG

Step 2: Select Fields & Relationships from the left panel and then click on the New button

0008.PNG


0011.PNG

 Step 3: Select Formula as data type then click Next  

0012.PNG

Step 4: Type Field Label Name (E.g., Opportunity current Stage Duration)

0013.PNG

Step 5: Select Formula Return Type as Number, select Decimal Places as 0 then click Next

0014.PNG

Step 6: In the formula field enter the formula

Formula:
NOW()- BLANKVALUE( LastStageChangeDate , CreatedDate )

Click on check syntax button to check any syntax error if any.

0015.PNG


Step 7:  Set the Field-Level Security for Profile then click Next, Next and click Save
 

0001.png

Create custom List View (Opportunity current Stage Duration View) on Opportunity object

Step 1:  Click on App Launcher (9 dots, upper left corner) select Sales click on Opportunity, then click on gear icon and click New to create new list view

0002.png

Step 2: Type List Name (Eg. Opportunity current Stage Duration View) List API Name will be auto generated then click on Save

Step 3: Click on gear icon and click Select fields to Display to set fields on list. From Available fields select fields and shift to visible fields to show fields on list then click on Save

0003.png

Here is the final result: 
 
Opportunity current Stage Duration View opportunity record page with
Opportunity_current_Stage_Duration__c formula field that is displaying Opportunity with the number of days it's been in that stage

0004.png

_____________________________________________

Written By: Divya Chauhan  | Salesforce Answers Leader 
Divya Chauhan is a Salesforce Architect at Kcloud Technologies. She has 10 years of Salesforce experience and is 25 times Salesforce certified, as well as 7 times Salesforce Architect Certified. She is a Salesforce Community group leader and founder of the NGO DivyaEdu.org, which provides computer literacy programs and free Salesforce training to underprivileged children and women in rural areas.

Submissions reflect only the opinions of the user who made available the Submission and not the opinions of Salesforce, regardless of whether the user is affiliated with Salesforce, and may contain or constitute products, services, information, data, content and other materials made available by or on behalf of third parties ("Third Party Materials).  Salesforce neither controls nor endorses, nor is Salesforce responsible for, any Third  Party Materials, including their accuracy, validity, timeliness, completeness, reliability, integrity, quality, legality,  usefulness or safety, or any applicable intellectual property rights. Any Submissions made available through any message board or forum in response to posted questions, or that otherwise purports to answer any questions, including any questions about Salesforce or Programs, are made available for your general knowledge only and should never be relied upon as answers to your specific questions (even if an answer is marked as a “best” answer or with any similar qualifications). You should always contact Salesforce support for answers to your specific questions. Salesforce has no control over Submissions, and is not responsible for any use or misuse (including any distribution) by any third party of Submissions.

If you have questions, tap into the wisdom of our entire Trailblazer Community here: https://trailhead.salesforce.com/trailblazer-community/feed

  
Номер статьи базы знаний

000395972

 
Загрузка
Salesforce Help | Article