-
Auto Refresh for Reports
I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a sheet, but who don't need to see all the columns on that sheet. This works well, except the user is forced to save and…
-
Find Reports w/ Specific Filter Conditions (critera)
A user has created probably hundreds of separate reports with varying Filter Conditions. Now I have been asked to updated all reports with a filter Region / is one of / PN or RM and replace it with Region / is one of / MP Is there a way (a) to do this search and replace on a batch of reports at the same time? Preferably…
-
What reports are tied to a sheet?
Hi - is there a way to see which reports a particular sheet is feeding?
-
Formula to countdown contract expiration dates
I have a sheet that lists all active contracts for my department. The sheet houses the contract details such as Contract Name, Contract ID #, Vendor, Start Date, End Date and Extension Date, etc.… I am currently using =[Expiration Date]@row - today() as the formula in an adjacent cell to countdown the days until the…
-
Grouping limit in reports? Data cut off, not collapsed.
Hi there, I know there are some limitations with grouping in reports, but I don't think I've run up against them just yet. I have a report with 2,059 rows but when I group them, the report only shows 1,974 rows. I tried removing some columns to reduce the overall number of cells, but that didn't help. I don't see any…
-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
Reports vs. Sheet (reporting / dashboards)
I am struggling because I have a very large SHEET that has many many data points that I have created a REPORT to create a BUDGET summary and projects for Quarterly Portfolio review(s); however, NOW I have to create a REPORT from this REPORT so I can create WIDGETS / Charts on a Dashboard; however, I know it isn't a thing…
-
Having Indented Children enter and leave Reports with Parent
Good Morning Community, I use reports to give concentrated views of our Master SmartSheet to Project Managers for ease of use and navigation. One example of such a report is an Overdue Est. Installation Date Report that populates into the report when the Est. Installation Date is in the past. I would like the Parent to…
-
How do I make a Basic Cashflow Line Graph?
I have to think I am just missing something obvious, because I am having the most difficult time using the Dashboard to create a Line Graph that shows my cash flow over time. I tried using only two columns (again, this is a very basic chart) that has the dollar amount figure, and the date that the amount was recorded. My…
-
Create a chart from the sum of columns
Hi, is there a way to create a chart from the sum of columns in a report? Attached is a screenshot - I just want to chart the Sum row. Thanks!