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.
Comments
-
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.
