+ Start a Discussion
Denver GreeneDenver Greene 

Opportunity field equals one value from related list.

I have a opportunity in a master-detail relationship with a custom object (related list). I need a field in the opportunity that takes a value from the MOST RECENT related custom object.

Opportunity = textbook adoption
Custom object (Class Size) = number of  students in class.

Every year there is a new class size, so we need to be able to see the sum (rollup, which I have) and we need to see the current class size. Various other formula fields run off of value.

I haven't found a way to do this using regular formulas, so I fear I need to use Apex.

Forza di SognoForza di Sogno
Fear not - you can download the Rollup Helper app from the AppExchange and build a query with it, to find the most recent related object record and stamp its value onto your opportunity.