Modern SharePoint Online - Multiple titles displayed for an event

Question

Hi,

I have created a calendar on Modern SharePoint online version with a few custom columns added in such as a 'Team' column.

At the moment when I go to create an event and submit it, I can only get one of the column title values to appear on display on the calendar, such as my name or my team:

'Team 1' or 'John Doe'

Is there a way to have these two values combined so that when a new event is created, it will be displayed as:

'John Doe: Team 1'

Answer 1

Yes, you can combine the values of the 'Team' column and the 'Title' column into a single value and display it on the calendar.

To do this, you can use a calculated column in SharePoint. Here are the steps to create a calculated column:

1. Go to your calendar list in SharePoint and click on the gear icon in the top right corner.
2. Click on 'List settings' from the drop-down menu.
3. Scroll down to the 'Columns' section and click on 'Create column'.
4. Give the column a name, such as 'Display Title', and select 'Calculated' as the column type.
5. In the 'Formula' section, enter the following formula: =[Title]&": "&[Team] Note: replace "Title" and "Team" with the actual names of your columns.
6. Select 'Single line of text' as the data type returned from this formula.
7. Click on 'OK' to create the column.

Now, when you create a new event on your calendar and fill in the 'Title' and 'Team' columns, the calculated column 'Display Title' will automatically combine the values of these columns into a single value in the format you specified. This combined value will be displayed on the calendar.