-
To much Dynamic data
I have 12 grids (One for each month) that have dynamic (Column 1)offices, (Column 2) Appt Types. (Column 3) Amounts for those appt types, I need to combine them into 1 report but the report starts over each month stacking. So i though i would combine all 12 months into 1 grid but then i end up with duplicates(Offices and…
-
Monthly Rolling report
Hi, I'm looking to create a report that has a filter based on the previous calendar month. Currently I have to change the filter on a report each month and let the users know the previous month's activity is ready to view. I'd like to be able to do something automatic so on the 1st of each month the report changes and…
-
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…
-
Merged: Single Dynamic Filter
This discussion has been merged.
-
Adding to a report
Hello! So - I am working on building dashboards for my company where we can track To Dos. goals, etc. I have made reports, added them to the dashboards, and connected the report widget back to the data source (data source being the report NOT the original sheet). My question is - is there a way for people to just add line…
-
Move report to another workspace / folder?
I am completing the capstone project for the Core App Learning Path in Smartsheet University and created the report it asked me to create for rows 34 and 35 under the "START HERE: Core App Skills Badge Exercise". It explicitly advised that I need to ensure the report is created / organized under the provided folder but…
-
Help Pulling Information
Hi, Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer from one of the columns. I'd like to pull information from 3 sheets into one based on what is listed in one column and in…
-
Two Sheets in One Report using same column
I have two sheets referenced in a report. Both sheets have column "A" which is a date column. Since Sheet #1 is the source, I would like to only pull column "A" from Sheet #1. Sheet #2 references(using formula to index match) Sheet #1's column "A" just for information. It seems when I use only Sheet #1 in the report, I can…
-
Ability to modify report filters on mobile devices
Please extend the capability to modify filters within a Report to mobile devices. This feature, presently accessible on desktop, should be available on mobile platforms too to enable on-the-go adjustment of parameters. The absence of this functionality currently compels Report creators to generate numerous reports in…
-
Can you pull reports to run automatically each month for each different location on 1 sheet?
Alright! Pro Desk is booked out over a month for what I need, SO I am hoping to get some insight from you guys! Currently I am making a sheet/intake sheet that is populated through form submissions. There are about 30 different manufacturing plants that will use this form and within the form there is a dropdown for them to…