-
Allow Summary from Report Group as a metric option on dashboard
The grouping and summary feature is great and in some circumstances may replace the need to create some sheet summary fields. However, in absence of being able to use as a metric on a dashboard, unfortunately this duplication may still be required.
-
What formula to use to count all instances of a value across multiple columns.
Hello, My colleagues have set up a sheet to help them track sustainability actions in their department. They've asked me to help with setting up reports and a dashboard that summarise and calculates the types of actions across the 4 Action type columns, as well as summarising further by team. As you can see there's been an…
-
How to make a "Tasks by Status" Widget on Dashboard
Anyone have a clue how to make this Tasks by Status Widget on a Dashboard? Is this made using a report or is it just a widget? My goal is to list how many Tasks are on a report that are green, yellow, and red in the same exact format shown. Thank you!
-
How do I add a contact to a report that’s pulling select tasks from multiple project schedules?
Newer user here!! What’s the best method to pull a contact (PM Assigned To) from an intake sheet into a report that’s already pulling select tasks (Materials) from multiple project schedules? I'd like to be able to show the project manager, as well as sort by PM, for the project on a materials report; which is a list of…
-
Best Way of Being Able to Display Data Using a Current Sheet, Archive Sheet and Summary Reports
Hello, I'm assisting some colleagues with a solution that helps track music session bookings. There are a number of summary reports set up, which the metrics are then displayed on a dashboard. It's been set up for exactly a year, but they only want the current financial year's data to be displayed. They came to me asking…
-
Form to filter report
I have a SmartSheet Form collecting information for room areas for different building types. Can I have a checkbox for each room? If the box is checked, the Recap Report will include it in the room area calculation.
-
Using Formulae within Smartsheet Reports
Hi all, I am working on a project to aggregate data on a pan-European level with different Smartsheet files, a file per country. I bring all these different country Smartsheet files together using the Smartsheet report functionality. Some of the country data is in local currency and/or in square feet. I would like to have…
-
Copy Row by Automation
I'm copying rows that meet specific criteria from multiple project sheets into a single different sheet using an automation. When looking at the destination sheet, is there an easy way to determine what source sheet each row came from? Similar question for reports - If a report is collecting data from multiple different…
-
Merged: Save multiple filters in a report
This discussion has been merged.
-
Report by user: Filter empty for only one user
Hi, I have created a report by user and it works fine for all users of my sheet with the exception of one user. The field that I have marked in yellow below is showing empty for this one user and therefore not pulling the data for her, she only gets a blank sheet. How can I fix this? Thank you! Christine