-
Reports Filter Criteria Behaviour
Hello Exports, I am building a report based on a source sheet. The report should extract the rows based on the criteria "This Week". Can you please take a look the pattern of screenshots and confirm if this is an expected behavior ? The data's appearing only when I am using "Is One Of" but not the other conditions. The…
-
Better Sorting for Sheet Summary Report
If you have several dates listed in the sheet summary on a project, then you can have an option for those to be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of…
-
Renaming Column Name in Report
1) Is it possible to change the Name of Column in Report instead of Source Sheet. 2) Auto Columns name is appearing in the Report instead of Column Name (Ex. Created by , Modified By, Created Date and Modified Date). Is there any way to change System Columns name in the Report. Thanks for your support. Best regards.
-
Printed Report not keeping sort order
I have a simple report that has a sort order selected. Works great on the screen, but when I print the report, the sorting seems to have a mind of its own. I cant find any rhyme or reason of what its sorting. Trying changing the sort to other columns, but no luck. The only think Ive been able to notice is that at least its…
-
Sheet Summary/Sheet Summary Reports Questions
Hi, Is it possible that if you have several dates listed in the sheet summary on a project, that those can be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of dates…
-
Project Status Report > Horizontal View
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in…
-
Sharing Externally using Control Center
I'm new to using control center and I have an internal team that wants to use it to create client specific reports and dashboards in addition to our internal information. The problem is there is certain information on the sheets that I don't want the external client to have access to, so I can't share a report with them. I…
-
Enhance Smartsheet with 'Current User' Filter Option in Row Report Summary
I would like to suggest an enhancement for Smartsheet that involves refining the Current User filter. It would be beneficial if the filter could include Admins or Owners from viewing the task list if they haven't been assigned any tasks. This feature would enable Admins or Sheet Owners to view tasks even if they haven't…
-
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…
-
Smartsheet Calendar - Removing Completed Tasks from the View
Hello, I have been investigating the capabilities of Smartsheet Calendar and was most interested in how to use it to track multiple projects through a Smartsheet Report. The report I've created pulls from several projects, all containing a "Completed" column with checkboxes to mark status for tasks. In setting up a…