Help

Adding Collaborator initials in a formulas

Topic Labels: Formulas
4800 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Brite_Admin
7 - App Architect
7 - App Architect

I want to use a formula to add the Collaborations initials to the Event name so I know who is going just by looking at the primary field name in the calendar view but I am unclear how to accomplish this.

10 Replies 10
Lauten
4 - Data Explorer
4 - Data Explorer

Try out the MID function for the second initial in Name (example: “Eric Koston”):

LEFT(Name,1) & MID(Name,FIND(" ",Name)+1,1)

Returns: “EK”