Calendar view that displays the allocated resource

Dan Blocker

I have several project spread sheets with resources allocation. I built a report that brings the spread sheets together to display the tasks assigned to the various days. I would like this same calendar data to dislpay a calendar view of the resources allocated to the various days. The questions is how? The calendar view only seems to display the primary column which is the task. I need to know the resource assignments in a calendar view.

 

Thanks

Dan

Travis

Hi Dan,

 

The calendar will always show the text from your primary column. You can concatenate to include more information, such as resources. 

 

For example, add this formula to a primary column cell:

 

="Job X | Resource: " + Allocated2

 

Replace the first part with any text you want to include and replace Allocated2 with the cell reference of the cell containing the information you want to concatenate.

 

This would result in:

 

Job X | Resource: John Snow