
Coverage_Team__r.Name has been added to the Account
Coverage_Team__r.Name is a reference field. the rest is static text I want to add.
If the forumla is- Coverage_Team__r.Name - it will display the referenced field.
If the formula is - 'has been added' - it will disaply that text ok.
If the formula is-
Coverage_Team__r.Name 'has been added'
If it is - (same but with 2x quote)
Coverage_Team__r.Name "has been added"
I get:
Error: Syntax error. Found 'Coverage_Team__r.Name'
WTF
Please assist. I just want to combine a referenced field and static text. Thanks.