-
Calendar App - Permissions
I understand that users have access to the calendar app calendar for a particular item if they have access to the source sheet or report. If I create a report that looks at two sheets and then give view access to a group that only has access to one of the 2 underlying sheets, they will only see the information from that…
-
I Want to Filter Based on a Status and Date
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
-
Sorting Columns in Report Widget in Dashboards
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
-
WorkApps: Different report filters for different roles
When using WorkApps to provide restricted access to data, it would be great if we use that same report across different roles by apply different filters. This would allow us to use a single report for the WorkApp instead of creating lots of identical reports. Situation I have data from different departments that I want to…
-
Merged: Ability to filter a report in a Workapp
This discussion has been merged.
-
Ability to sort by columns in Report Widget
-
Report filters are locked and I'm unable to edit them
When building this report an incorrect filter was added to the report (see picture). After it was added, we were unable to delete the filter, edit anything within the report, or edit columns in the sheets tagged to the report. Does anyone have a solution to this?
-
Using Smartsheet for SOP / policy acknowledgements?
I’m exploring using Smartsheet as a central place to manage SOPs and internal documents and was curious if anyone is actively using it this way. Specifically, I’m interested in how people are handling things like: Notifying staff when a new SOP or document is posted or updated Requiring staff to acknowledge they’ve read it…
-
Custom Column View Templates
Is it possible to save custom views for columns? I would like to be able to show, hide, sort, and order columns via a template. I am able to filter based on specific conditions but I also need to be able to view the data a specific way.
-
Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…