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 with multiple date colum
Hello:
I have prepared a Master Calendar to have all our events in one page. Nevertheless our situation is not that our dates come from different smartsheets but that the dates come from different columns in the smartsheet. Eg. Date #1, Date#2, Date#3 in one line (different columns). This is because sometimes our Xservice may be divided in different dates yet it is still attached to the same control number (auto number column) for all other purposes.
Please advice,
Thank you,
Mariemma
Comments
-
Hello Mariemma,
The Calendar view in a sheet can only look at one date column at a time.
To be able to view all of the dates you need in one view, you can copy and paste the dates all into one column (using ctrl + c for copy and ctrl + v for paste).
Otherwise, you can split the date columns out into multiple sheets, then create a report that pulls in the data from all of them. You can view the report in Calendar view to see all of the dates. More on reporting here.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives