Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
NSC | Using Last Sales Activity in Custom Formula Field
Scenario:
Custom Formula Field to show the number of days since customer was last contacted based on Last Sales Activity, where contact = Message, Phone call, or User Notes activities.
Solution:
- Navigate to Customization > Lists, Records, & Fields > Entity Fields
- Store Value checkbox = is False
- In Applies To tab, enable records you would like to appear this custom field
- In Validation & Defaulting tab
- Set Default Value to
({today}-{custentity_date_lsa}) - Formula checkbox = Checked
- Set Default Value to
- Click Save & Apply to Forms
The Store Value must be unchecked when using a formula to make the sourcing work.
Do you have a question or want to share your tips on using the
🌟Q2 2026 Community Choice Nominations: Recognize a member who made a difference in our community!
🏆️ Earn Community badges for Refer a Member | Answer Accepter | Content Creator
_______________________________________________________________________________
Michelle Jabanes | NetSuite Support Community Administrator0