-
Method to show comments from a sheet on a dashboard
Hello, Is there a way to surface just the comments from a sheet into a dashboard? Right now I have a report where the comments are seen at the row level, which is a step in the right direction. The limitation is I can only see the comments in either the report or the sheet. The ultimate desire would be to display comments…
-
Metrics Sheet Pulling from Reports
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 but its hard to get that into a meaningful chart. One specific example is we have 90+ sheets with rows that contain a rating…
-
How can I set Report widgets within a Dashboard to automatically update?
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 be labour intensive to have to manage each day. I want this data to be live, or at least updated daily because I am…
-
Can I use a Join when trying to create a report from 2 sheets
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 populated only from the Sheet it came from which isn't useful at all. Is this possible?
-
Reporting
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 could use in your reports that would allow you to just update the project group and apply to all reports using that project…
-
Formula issue
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 Applicable", "") IF(Act1@row >Act2@row , "Red") IF(Act1@row <Act2@row , "Green") THanks
-
Formula not working
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 Progress - Red else Green =IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On…
-
Smartsheet Report not capturing information
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 "Master Risk Log" for my organisation's project portfolio. I have built the report so that it captures specific information…
-
How to get a number of form submissions within a date range.
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 report things like 'how many form fills did we get last quarter'. I know I can filter my sheet to show just the rows that…
-
How can I rollup a sum using an id in two separate sheets?
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 request. The ID column in this sheet serves as a foreign key, which ties back to the one request made. I would like to try…
