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 Descriptions


Is there a way to display anything other columns rather than the Primary Column for a sheet in the Calendar view? I have reports that display specific tasks for many resources which I would like to run in a calendar format. This would be ideal for me if I could choose which column to display for the task such as the Assigned To columnn. 


  • Heidi Decker
    Heidi Decker ✭✭✭✭✭✭

    Hi Chris,

    What I do is this...

    1. Create another column that will hold what is now in your Primary column. Move that data to the new column.

    2. Put a formula into the Primary column that will pull together the other columns like this.   =[Job Number]6 + "," + [Assigned To]6 + "," + [Assign To 2]6.

    What this does, is puts my job number, assigned to and assigned to 2 all together in the Primary column. That is what shows on your calendar and gantt.

    See how that works.



    There is a formula Smartsheet Sample Template that helps with formulas.

This discussion has been closed.