Skip to main content

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"?

1 resposta
  1. Jonathan Fox (Intellect AI, Intellect Design Arena) Forum Ambassador
    3 de nov. de 2023, 17:23

    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',

    ''

    )

    )

0/9000