I'd like to explore the possibility of turning data collected and available to view as checkboxes into a viewable narrative. As an example within our org, if a contact has a checkbox marked as TRUE confirming them as a 'volunteer' and also has a checkbox marked as TRUE that they are interested in 'personal opportunities', how would I go about creating a formula on a new text field which draws on that data to explain "This contact has expressed an interest in personal opportunities for volunteering"?
Jonathan Fox (Intellect AI, Intellect Design Arena) Forum Ambassador
You could do something like:
IF(
AND(volunteer__c, personal_opportunities__c),
'This contact has expressed an interest in personal opportunities for volunteering',
IF(
volunteer__c,
'The contact is a volunteer',
''
)
)