-
How can I find reports for another group?
I have been asked by another group I work with to help with out with a SmartSheets problem since I am currently the one that works with it the most here. They have a process set up from a previous (and much more knowledgeable) user that is supposed to provide them with monthly reports on what each of their teams has done.…
-
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…
-
Is it possible to schedule send an Excel attachment with collapsed groups?
I'm trying to send an Excel attachment once per month from a row report that includes collapsed groups, but when the recipient downloads the attachment, the groups aren't collapsed like they appear on the live report. The data needs to be subtotaled by cost center - which could change every month, so a summary report is…
-
Dashboard Sheet name Hyperlink proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…
-
Toggle Show/Hide Sheet Formatting on Reports within Conditional Sheet Formatting Modal
Wondering whether anyone else is running into this inconvenience. Issue: Often times, I have formatting on a sheet that I would rather not show on a report. There are a few workarounds but the added control would be handy. Idea: If there were a way to set a value/toggle within the conditional formatting modal when creating…
-
Summarizing Within Reports
Community, I have generated a report of a sheet and gotten everything filtered, grouped, and summarized as I want. However, the "summary line" is blank. This is because when I try to summarize a column, I can only summarize "count", "sum", "average", "minimum", and "maximum". I want it to display the text that is within…
-
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
-
Setting up Data & Configuring Gradient Bar Chart
Hello! I am trying to show a gradient bar chart in a dashboard. I have a sheet where I've pulled a report that has data for US States. Each state has a count for Yes, No and Blank. I want to represent a bar chart in a dashboard for this data that shows the Yes, No and Blank count information as a gradient. Below shows the…
-
Possible to change the Resource Allocation End date in bulk for one project.
We have a large number of resources for multiple projects. For us, it's very difficult to change the allocation when the project date has been changed. If you can work on this, we can extend the resource allocation end date in one way for all the resources in the single project, which will help us minimize our effort for…
-
Problem with Multi-sheet Report interpreting identical columns as unique
I am having difficulty with not understanding how to force SmartSheet row reports to understand that a particular column I have on multiple sheets is indeed the same thing, and I want it displayed on the report as a single column. It somehow does this automatically and sometimes correctly identifies this, other times not.…
