Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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 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
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
