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