- Remove Column Headers in Report Widget
Report Widgets when using only 1 column are very difficult to design and integrate into a dashboard. You can either not have a title but then it does not match other widgets or use a title but then it basically has 2 titles. See below images. Without title: With Title: The option to remove the column headers would allow…
- Impact of archiving on non-Dynamic Reports?
When I archive a project, what happens to any reports that are not set up as Dynamic Reports? Is there a way to automatically continue including them in those non-Dynamic Reports? I know you can retain archived projects in Dynamic Reports, but these do not fit that condition. Thanks for your help.
- Smartsheet Calendar Column and Task Names color not aligning
Hi there, I'm currently pulling 4 separate grids into a single report to create a collision calendar. The calendar is color coded by sheet name. I recently added the 4th grid into the report and now the colors are not aligned. I created the custom colors by Sheet name previously but I cannot recall how to fix. When I go to…
- tracking # of employees quarter over quarter
I'm trying to show on a graph how many employees we had in each quarter. How would I do that? My initial idea is to add a helper column for each quarter, and add a formula to return a 1 if any of the date range of that quarter falls after their start date and before their end date, then pull a report counting the 1s for…
- View parent (and child) rows in report?
Is there a way to view parent and child rows in a report? Asking as using the std project dashboard with 'At risk tasks' report (from the schedule). This surfaces rows where due date is in the past and status other than complete. However, for lengthy schedules it surfaces child rows that have no context when in a long list…
- Checklist Report
Hello, In my smartsheet, I have something of a checklist with all checklist items on a new row. Each item is accompanied by about 5+ columns for "Checklist Item" "Complete?" "Due Date" "Close Date" "Notes" and so on. The checklist is to be duplicated for each new program we launch and contains 124 checklist items. Since we…
- Reports column problem
Hello, I have added a column that is a dropdown list allowing multiple values per cell. It shows up and works in the main sheet, however, the report will not show the options. What is going on??
- Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
- Update Request Links
Hi - I'm wondering if there's any way to capture the actual Update Request link (what comes through in the email when you send the Update Request) in a report? Our account people get tons of Update Requests, and don't always have the info to follow up immediately. So, rather than have to sift through emails, is there an…
- How to - Create report filtering on rows containing "Pending Open Update Request"
I have not found a method/solution to generate a report on the leftmost system columns and various statuses such as "Pending Open Update Requests" or has attachments, etc... Suggestions or How-to would be greatly appreciated!
