-
Issue with report not displaying all rows on Dashboard
I created a report based on a date, which itself is the result of a formula based on a number + an Assigned Date. The report displays a count of each row that has a particular date. The issue is that the dashboard will not display the first row with a count (see screenshots). When I re-sort the data to display the newest…
-
We need a search option in the dashboard to pull out rows matching keywords provided by the user.
Example: We used dynamic view to create a web content widget in Dashboard. We are able to use Filter option to bring out status of rows but it would be very helpful if "Search" option is present. Our expectation-- By entering a keyword in the dashboard widget it has to pull the rows of smartsheet table having the…
-
how do i update the 'action tracker' status column from the action tracker updater sheet
I want to make a system where not everyone can see my action tracker sheet. What can I do to ensure that the status column can be updated to whosoever the action has been assigned to without them having to see the full sheet
-
PowerBI Connector has intermittent issues (due to smartsheet network?) - Anyone having similar issue
Hi, Is anyone else having issues with using the Power BI Connector to access Smartsheet data in the last couple of weeks. The network performance seems to be extremely sporadic and is getting worse. Nothing has changed in the configuration of the PowerBI dataflow nor in the amount of data being requested. Errors when they…
-
How do I reference a Report Summary Field into a formula
I created a Sheet Summary Report for one of my Sheets. The Sheet Summary Report is grouping by JOB NAME and giving me MAX values for certain criteria I have a metric that is calculating a RATE and I do not want the MAX value of this rate in my sheet I only want the rate for the row in my sheet that has the 2 MAX values.…
-
COUNTIF or SUMIF Formula in Report Summaries
Currently the summary count function only supports basic formulas. It would be great to be able to have the ability to use a COUNTIF or SUMIF Formula in report summaries. Specifically to count only the checked boxes. This feature would be nice to roll up metric data quickly and avoid the need to create a separate metric…
-
Join ancestors EXCEPT the top level
Hi Smartsheeters, I would like to group my milestone report by workstream, so I added a "join ancestors" column. I also have a "count ancestors" column that can be used. My current report is a nightmare when sharing, as the top ancestor is the project name, and I can't control how massive (and not wrapped) the group header…
-
Help with Totaling Against Options in Multi Select Drop Down in a Report?
Hello! Here is my scenario - I have a set up like this in my sheet (this is of course dummy data just to give a visual of the sheet structure) - I am trying to create a report grouped by the "Assigned To" so that I can summarize the # Hours each person is assigned, and then have a chart widget from that on a dashboard. I…
-
Information page
I would like to have a sheet with all of my part numbers and the various information that pertains to each part number on it. I would then like to have some sort of sheet or report that has a dropdown for me to select the part number I am looking for, then it will populate all of the information for that part but in the…
-
Report - Recent Changes
Having a Report that you could run on a Sheet to show recent changes/cell history would be extremely helpful. This would allow for admins to drill down into recent changes and understand potential next steps to take. Also, having a Report that would show recent changes could be easily exported out and shared with…
