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.
Report Error
Hello,
I am trying to create a report that brings in multiple date types so that I can use the calendar view to see my marketing and PR activity. I created a marketing campaign tracker and PR campaign tracker. The marketing campaign tracker has a launch date and end date and the PR tracker only had one date. I tried to pull all the info together but it wasn't appearing so I tried adding an end date to the PR campaign to see if it would collect this data but it still isn't working. I named the Marketing campaign dates Launch Date and End Date, but the PR tracker header only says Date, is this the issue? Do the headers have to be the same, even though I am adding extra columns? I can create a report asking for the Launch Date, End Date and Date, no data shows? Do the headers have to have the same name?
Comments
-
Make sure all of your date columns in each sheet have exactly the same name, and are both set as "date" type columns. This should funnel both columns into a single report properly.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives