Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Calendar view that displays the allocated resource

Dan Blocker
Dan Blocker ✭✭✭
edited 12/09/19 in Archived 2015 Posts

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.





  • Travis
    Travis Employee
    edited 12/22/15

    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

This discussion has been closed.