The loan officers can keep track on the loans which are approaching the estimated closing date by highlighting them on the list view. It can be customized by color coding loans based on their estimated closing date. The recent ones can be coded red, later ones green and the farther ones in yellow. In this way we can highlight loans or applications needing attention.
Fields required in the Loan Layout
- Estimated Closing date: This is a date field which is to be entered by the LO on the Loan detail page.
2. Loans Needing attention: This is a formula (Text) field. In the Formula editor, type in the formula to highlight loans as per the desired color code.
Red – Est. closed date within 3 days.
Green – Est. closed date between 3 to 10 days
Yellow – Est. closed date more than 10 days.
For displaying the color, save the colored image anywhere in your computer. Upload the color images in the ‘Files section’. Copy the link of each image and paste them in the formula editor at respective places within the brackets of the IMAGE function.
3. Days to Close: This is a Formula(number) field which calculates the difference of the Estimated Closing Date and Today’s date. This field is an optional one. In cases where we need to display only one of the segments listed above in the list view, we can use this field in the filter.
Now click the App launcher. Go to Loans tab and create a new list view to highlight the loans needing attention.
To learn how to create list views in salesforce, click Work with List Views in Lightning Experience (salesforce.com).
If required, Go to Filters-Add filter to choose the Days to Close the loan less or equal to 3.
For more specific use cases in Jungo/Salesforce, Contact Us Now
Take Five Consulting is a technology company, based in Virginia U.S., that specializes in the Mortgage Banking vertical especially LOS implementation and application development. Take Five Consulting creates and implement mortgage technology and software specifically for Mortgage Industry.