Reports
Discussion List
- Hello All, I'd love to know if its possible (or a workaround) for creating a metric sheet to use in a dashboard using data from reports. We have 90+ Sheets that we can easily pull data into a report b…
- I am using multiple report widgets in a single Dashboard to show test result data. The only method for updating the widgets to show the latest data is to open the source sheet and save it. This would …
- I want to "Join" the data from one sheet to the other sheet in a Report using the Primary Field so that I only get 1 ROW with all the columns filled in. Instead, I get DOUBLE primary each with data po…
- We manage several hundred projects that we report on in numerous ways. When new projects are added, we must also add them to each report criteria. Is there a way to define a project group that you cou…
- Hi Can someone help me to write these five formula in a single formula to get the schedule health. IF(Status@row = "Not Started", "Gray") IF(Status@row = "On Hold", "Yellow") IF(Status@row = "Not Appl…
- Hi , Can anyone help me with this formula issue:- I have 4 symbol color- Not Started- Gray Not Applicable- No color On Hold -Yellow Complete- Green Act1 greater than Act2 and Status is equal to In Pro…
- Hi all, I hope you're all well and having a great start to the week! Hoping you can help me, as I'm having issues with Reporting on Smartsheet. I'm trying to put together a Report that will serve as a…
- I'm looking to put together a dashboard and on it I would like to display a number. We collect work requests via form fills. Each form fill creates a line in my sheet. And I would like to be able to r…
- I have one sheet, the Purchasing Request sheet, which tracks a single request made. The ID column serves as a primary key here. On the other sheet, I have items that are tracked and related to a given…
- I am creating a chart on a dash board using a sheet summary report pulling data from 2 sheets. I am having difficulty arranging the columns as desired no matter how I adjust the widget tools or the co…
