Is there a way to create a formula field on the Account object that pulls all values in a picklist field from All related Contact records? IE: Contact has a picklist field named "Program". I would like to create a formula field on the Account named Programs which lists all the values from the Program field of all Contacts related to it.


No that's not possible with only a formula field. You will need to either:

  1. create an APEX trigger on Contact for this, or
  2. use a combination of roll-up summaries (1 for each of the programs, with a SUM of all Contacts having that program) and a formula field (rendering the program names based on the roll-up summary fields). This might not be a good option if you have many different programs
  • Thanks for the info and suggestions. We don't have a developer on the team so I might try number 2. – user7417 Jul 10 '14 at 11:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.