Calendar View Descriptions

Chris Easterwood

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

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.

Peace!

 

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