To record the most recent Opportunity close date on Contact records and update it upon new Opportunities, which feature should be used?

Using NPSP Customizable Rollups is the most suitable option for recording the most recent Opportunity close date on Contact records and updating it as new Opportunities are added. This feature is specifically designed to aggregate data from related records – in this case, Opportunities associated with a Contact.

The customizable rollup allows users to create a field on the Contact record that will automatically pull in the most recent close date from related Opportunities. This means that as new Opportunities are created or closed, the latest date is reflected in the Contact record without the need for manual updates or additional complex workflows.

Other options, while they serve distinct purposes, do not provide the same level of functionality needed for this specific use case. For instance, a roll-up summary field could aggregate data, but it is limited to master-detail relationships, and it cannot dynamically sort and select the most recent date. A formula field calculates values based on existing fields rather than performing lookups or aggregations from related records. An AppExchange app might offer various additional features but may not specifically address the functionality required for roll-up capabilities that the NPSP Customizable Rollups provide.

Thus, leveraging NPSP Customizable Rollups directly addresses the requirement of tracking and updating the most recent Opportunity close date