Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I rectify this?
It is essential this information is displayed, and allows interaction. I know Smartsheet did allow this in the past, so not sure what I am missing.
Best Answer
-
Hi Peta,
It does not matter what kind of columns (free text, dropdown list, dates etc.) there are in original sheets all of them shall be visible in the reports that you create out of them. What can be the issue is that despite all the columns have same name they could have different properties like sometimes "project status" can be "dropown list" and sometimes "project status" can be "text" in that case in reports there will be the column twice but also empty.
Please make sure all the columns you are taking in the report have the same name and same properties.
Let me know if it helps.
Regards,
Answers
-
Hi Peta,
It does not matter what kind of columns (free text, dropdown list, dates etc.) there are in original sheets all of them shall be visible in the reports that you create out of them. What can be the issue is that despite all the columns have same name they could have different properties like sometimes "project status" can be "dropown list" and sometimes "project status" can be "text" in that case in reports there will be the column twice but also empty.
Please make sure all the columns you are taking in the report have the same name and same properties.
Let me know if it helps.
Regards,
-
Thank you Tomasz,
That explains it! I Knew it had to be an ID-10-T error on my part! -
awesome! Happy to help
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 376 Global Discussions
- 205 Industry Talk
- 437 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives