Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
There is no direct way to reassign the Primary Column.
You'll need to:
1. create a tempoary column
2. copy/paste the data from Primary Column to the new column.
3. copy/paste the data from the column you would have liked to make the primary column to the Primary Column.
4. copy/paste the data from the temporary column to the column that you wish had been the primary column but wasn't.
5. delete the temporary column
6. rename the two columns, the Primary Column and the one-that-wasn't.
Craig
Excellent workaround advice Craig! Worked like a charm