I have this formula text calc to concat 3 different fields on a project and put them on their own lines. But I’d like to insert text before each one and am stumped on the syntax to use ‘text: ’ or || ‘text’ || - can anyone point me in a direction? CONCAT({custentityengagement_coordinator_c},CONCAT(CONCAT(‘<br>‘,{custentityprogram_manager_ms_c}),CONCAT(‘<br>’,{custentitycustomer_success_advisor_c})))

'text: ' || {field1} || '<br>text: ' || {field2} || '<br>text: ' || {field3}

which can also be written as this for readability:

'text: '||{field_1}||'<br>'||
'text: '||{field_2}||'<br>'||
'text: '||{field_3}

CONCAT('Text1: ', {custentityengagement_coordinator_c}) || '<br>' || CONCAT('Text2: ', {custentityprogram_manager_ms_c}) || '<br>' || CONCAT('Text3: ', {custentitycustomer_success_advisor_c})

why use

CONCAT

at all? You could just go full in:

CONCAT(CONCAT(CONCAT('text: ',{custentityengagement_coordinator_c}),'<br>'),
CONCAT(CONCAT(CONCAT('text: ',{custentityprogram_manager_ms_c}),'<br>'),
CONCAT('text: ',{custentitycustomer_success_advisor_c}))

But I know which one I'd rather use

Thank you! I’m just getting the hang of formulas and was referencing one our NS func consultant used a while back; obviously will use your first one - appreciate it!!