-
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…
-
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…
-
Return just one row in my report
I wanted to create an ability in my Workapp or Dashboard that would pass the filter criteria to a Report and show only the filtered rows. Is that possible? Is there a workaround?
-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Can't share info on mobile device via Dynamic View OR Workapps?? what is the solution then?!
SO we can't share via reports unless we add all users to the sheet. SO we buy dynamic view and enterprise licensing and add our dynamic views to a dashboard and share the published dashboard. SWEET, wrong. Now we can't use dynamic view when viewing the data by mobile devices (and that is our whole point- easier access/view…
-
Resource Management analytics report showing phase dates
How do I run a Resource Management analytics report to show phase dates? It only seems to show the total project dates.
-
Has the report grouping functionality changed to allow more than 2500 lines?
Hello, We have some regular reports that we pull data from that are grouped and have over 2500 lines. These reports have always hidden the lines because grouped reports can't show more than 2500 lines. As of this morning I noticed that now my grouped reports have multiple pages at the bottom and I can see the lines within…