-
Display different report based on day of week in dashboard widget
Hello all, New user here. I am building an updated dashboard for my job and I was wondering if there is a workflow that will allow a report widget to display a different report depending on the day of the week? I have used other examples here in the community to add a widget that displays the days date and day of the week……
-
Automating Monthly Generation of Multiple Reports
Hello Smartsheeters! I have 14 reports that pull data from a master sheet that we need to report to an Important Entity each month. I'm hoping I can get out of the routine I have now, which is to save the batch of the prior month's reports as new and manually update the date parameters and the title for all 14 reports. For…
-
Why does it take a long time for my report to update its alphabetical order after I rename sheets?
I have a report that I'd like to appear alphabetically. When I update the names of my sheets to reflect 1, 2, 3, etc based on the order I want them to appear, the report doesn't update sometimes until days later. Is there something else I should be doing besides refreshing, signing in, signing out, etc to get this…
-
Linking restored files back to existing reports
I have a summary report that collates updates on all my team's projects. Earlier this week a colleague accidentally deleted one of the project sheets. The sheet has now been restored and the owner has confirmed everything's working as it should. However I now can't link it back to my report…?! When I look at the sheets to…
-
Improve Functionality of Report Filters
I'd like to see report filters improve. I've included a post from another user that was submitted a few years ago. Ideally, the report filter would allow for @row references. The use case that triggered this need for my company was the "between" function for a date field. I want to see any projects that are between two…
-
Multiple Filters In Reports that Collaborators can Choose/Select
I want to be able to develop 1 master log and create reports and forms for employees to use to change or add data. In order to change filters, I believe you need more permissions than an editor. To follow through with my idea, the editors would need to be able to change the filters. What if we had the option to lock or…
-
Any ideas on an easy way to capture data on a rolling monthly basis and show on a dashboard
We are capturing different types of statistics for multiple different subject areas every month and need to: a) easily get people to update the data b) easily show it on a Dashboard I've tried multiple different ways of sheet design but I keep coming up again blocks - ie either data can't be shown in a graph or the…
-
Cross checking grids
Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love the recommendation. I have Registration forms for 2 separate trainings (Training 1 Registration) and (Training 2…
-
Automatically filter values that are '0' in reports
Hi, I have set up a report that reflects status updates. There are a lot of values here that are 0. When I project this, the chart is cluttered with legends that don't have any values . Is there a way to automatically filter out the any cells that have zero in them and only project the cells that have values in them…
-
Column Descriptions in Reports
Column descriptions from sheets should also be visible on all reports using that column. It is important information for anyone using a report, just as it is for those viewing a sheet. Thank you
