-
Allow Data Shuttle to use reports to offload data
Hi, I have a Dynamic report that gathers information from the same sheet across a number of projects and displays the lines that meet a certain filter criteria. Currently I have to export this to an excel file and add it as an attachment to the sheet that I want updated by the Data shuttle workflow. It would be good to…
-
Indexing the way to go?
We have a master list, utilizing Smartsheet to build a CRM, that will be completed by form entry or by sheet entry and can be completed by different team members who contact the same business. 1 - looking for ways to report cell history specific to a business filtered by business name 2 - looking for a way to group…
-
How do I report on the Intake Submission Date field from the Project Intake Sheet?
Hi, I'm using the PMO template. The "Intake Submission Date" column is system generated in the "Project Intake Sheet". Is there a way to pull this column into a report? When I create a report using the Project Intake Sheet, the Intake Submission Date does not show up as a field that I can select. Project Intake Sheet and…
-
Adjusting formula for created Row# to not begin from 1 e.g. begin with 88, then 89, 90... etc.
Hi, For context I've created a report that draws from 4 sheets as a programme level plan. I encountered an issue with the predecessors not reporting clearly from source sheet. For those who haven't encountered this issue, smartsheet uses the row# to assign predecessors, hence with multiple source sheets only the amount of…
-
Why no Move/Copy Methods for Reports
SheetResouces has MoveSheet & CopySheet methods, why are there no MoveReport / CopyReport Methods for ReportResources in the API ??
-
Create Report Summary, Similar to Sheet Summary
There really isn't anywhere on a report to indicate what the report is about, or give instructions, or anything. It would be nice if there was a "Report Summary" very similar to the Sheet Summary functionality but for a report. Then we could add report level information for end users using the report. Even just a place to…
-
Countifs Past 90ds referencing another sheet
Hi, I am trying to make a dashboard that shows the top 10 pieces of equipment with the highest number of issues in the past 90d. I have my primary sheet that collects the data (Primary), and a reference sheet I am using to collect a count. I am just struggling to have it filter the last 90d. Showing #invalidoperation…
-
Reports Showing Blank Results for Current User Filter
I'm sure this is user error but I've been trying to figure it out on my own and coming up blank. I have a couple of reports I've created and want to show returns based on the current user who is viewing the report. I've asked different staff to test the view and they are both getting a blank screen. 😫 I'm not sure what I'm…
-
Need report that only shows fields that are NOT blank
Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column will vary widely but some will be blank, and I do not want to show the rows that are…
-
Allow Count Unique Values Only In Report Column Summary
In addition to being able to count and sum a column in a report, I'd like Smartsheet to be able to count UNIQUE values within a group. For example, I have a report shows me all tasks from multiple projects and groups by project manager. If I try to count the Project column to see how many projects each Project Manager has…