-
Conditional Formatting - Reports
I have conditional formatting set up to change the color of a specific cell based on the selected option in that cell’s dropdown menu. I built a Report for my team yesterday based on this sheet, and initially, all of the conditional formatting displayed correctly in the Report. However, when a team member changes the…
-
Request: Report summaries should count checked = 1 and unchecked = 0 for Checkbox columns
Love the reporting column summaries feature for most column types. However, the Count summary option isn't very useful for Checkbox fields. I want to see how many "violations" there are which we denote with flags being checked or unchecked. I'd expect the following scenario to return "3" and not "5". Or am I missing a way…
-
WorkApps Not Loading
I managed/own all our WorkApps with embedded sheets, reports, dashboard, dynamic views, etc. inside them and they are not loading this morning. The error is similar to the one from yesterday morning through mid-day. Is anyone else still experiencing this bug? Thank you, Michael
-
Edit reports on a dashboard
Request We need an option for the report widget that would allow users to edit report rows while viewing them in the dashboard. The problem I'm trying to solve: I have a report widget on a dashboard that shows users their assigned tasks. I'm using the widget on a Dashboard to give the users one place where they can see and…
-
Allow hyperlinks from reports (including links to timeline views or other sheets) to open in a new tab
Our company uses Smartsheet to manage our projects and each row is a new project with one of the fields being a hyperlink to the timeline of the project. Every time we click the hyperlinked timeline in our report view, it opens in the same tab by default which is really frustrating because you then have to open a new…
-
Dashboard Barchart adding 2 extra data points 0 and 2 on every chart. When hover it does not show data total
I have a report that contains 2 types of data. Birdcage and Skid. For each one of these I want to show Quantity that shipped on one bar and quantity that is left to ship on a seperate. If you minimize the birdcage data you will see skid date the same way. Data is grouped by Type (birdcage or skid) then summaried by Qty…
-
How do you spread activity hours across weeks for a resource forecast?
Hi all — hoping someone has solved this before I go and reinvent it badly. What I have One row per project activity in a sheet, with columns for: • Developer hours • Design hours • PM hours • Service type/Milestone • Start date • End date What I want A weekly resource forecast — week commencing across the columns, service…
-
Search for Column in Sheet + Reports
A feature to locate a column via search would be extremely useful. It is difficult to locate columns in large sheets that approach the 400 column limit.
-
How can I get a live link to appear in a dashboard widget pulling from a sheet summary?
I have been using the Enhanced Global Updates feature in Control Center for the past year, and I want to have a widget point to project specific links, namely to MS Teams and Jira. The goal would be to enable stakeholders who have access to those know where to go when checking the project-specific dashboard. However, my…