Add Opportunity Scorecard Last Modified (Days) to the Opportunity Header
Inspired by a Client’s idea
This field shows how many days have passed since a ClosePlan Opportunity Scorecard has been modified.
Adding SC Last Modified (Days) is a simple way to help Users quickly understand the last time they worked on their Scorecard. Knowing this can help Users keep deals on track and keep the Opportunity information ‘fresh’.
Note: Each Organization is unique, so there may be steps needed that are not represented here. If this is the case, please reach out to People.ai Technical Success here.
Create New 'SC Last Modified (Days)' Custom Field:
Go to the Gear icon in the top right > Setup > Object Manager > Opportunity > Fields & Relationships > New
Step 1. Choose the field type
Type: Formula
Next
Step 2. Choose output type
Field Label: SC Last Modified (Days) (Or name it as you like: Scorecard Last Update, SC Days since update, etc.)
Field Name will auto-fill as MEDDIC_Score → change to: CP_SC_LastModifiedDays
Formula Return Type: Number
Options: Decimal Places: 0
Next
Step 3. Enter Formula
Select the Simple Formula tab
Select Field Type: Opportunity
Insert Field: -- Insert Merge Field --
In the formula field, enter: TODAY() - DATEVALUE ( TSPC__CPDeal__r.TSPC__ModStampSC__c )
Click the 'Check Syntax' button to ensure there are no errors
Description: Fill in as needed
Help Text: Fill in as needed
Next
Step 4. Establish field-level security
Select the needed Field Level Security for Profile (To select All, click the 'Visible' box on the column header until all boxes are checked)
Set all selected to 'Read Only' or as desired.
Next
Step 5. Add to page layouts
Add the field to desired page layouts
Example:
Save
Add 'SC Since Last Modified (Days)' to the Opportunity Header
Step 1. Create (Or edit existing) New Compact view and assign:
From any open Opportunity click on the Gear icon > Edit Object > Compact Layouts
Select System Default
Click on Clone
Step 2: Compact Layout Edit
Label: Compact1 (or a name you choose)
Move the field you created MEDDIC Score % from Available to Selected
Click on Save
Step 3: Compact Layout Assignment
Return to the Compact Layouts list (From any open Opportunity click on the Gear icon > Edit Object > Compact Layouts)
Select Compact1 from the list
Click on Compact Layout Assignment
Click on Edit Assignment
Compact Layout to Use: Compact1
Select the Record Types on which you want to display the field.
All selected Record Types will be highlighted when assigned.
Click Save
Step 4: Confirm
Open any Opportunity using the Record Type you selected and view to confirm the field is present.
Alternatively, the highlights section of ‘Page Layout’ can be used, dependent on the current layout:
From any open Opportunity click on the Gear icon in the top right > Edit Object > Page Layouts
Select the desired Page Layout
From the Highlights Panel at the top of the page layout, hover over the Highlights Panel and select the wrench (spanner) icon on the right
In the pop-up window, select SC Since Last Modified (Days) from either the ‘Top field' or 'Bottom field’ menu
Click OK
Click on Save in the top left to save the Page Layout
Click Save
Confirm
Open any Opportunity using the Record Type you selected and view to confirm the field is present.
Note: Salesforce will usually propagate the changes few minutes, but it can sometimes take up to 60 minutes for the field to display on the Opportunity Header.