-
Data Shuttle - Need to filter new hires within last 30 days
Hi everyone, I'm trying to set up a Data Shuttle offload that will export the following information into OneDrive: Employee Name Role Manager Employee Type Hire Date The problem I'm running into is that I am not seeing any viable way to filter the results within the last 30 days. I setup a report for this as well but…
-
Summary Sheet/Report/Cards/?
I have no idea how to even approach this. I have played with using a report summarize some data using different views, but the formatting so limiting that I cannot get anything useful. I have a main sheet that tracks evaluations. For this summary I want to show just a small bit of data. I have columns that I want to use in…
-
Dropdowns in a dashboard, is it possible?
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total sales for each month, and even quarter, down to how many projects they have completed…
-
How do you apply text wrap to the sheet name column in a report?
Since this is not a column from the underlying sheets, but rather a system-generated field, is there a way to apply text wrap to this column in a report?
-
Can you move the grouping in reports above a different column?
I am trying to report on sheets with different primary columns so I want to hide this in the report but doing so hides the grouping as well. I tried changing the column order before adding the grouping but then it reverted to having the primary column on the far left.
-
Banded Rows for Reports
It would be nice if reports created banded rows automatically instead of having to create complex formulas in the source sheet to band rows that flow through to reports. Most of our reports come from one master sheet. If I create banded rows based on one set of criteria, it works great for that specific report. However,…
-
Trying to consolidate specific rows from multiple sheets into one
Hi, I currently have 11 project plans and I would like to consolidate specific rows (e.g., rows related to a specific system) within those plans to a master plan, where I would add additional columns to edit. I looked into reports and linking cells, but these don't seem to do what I need. The consolidated report should be…
-
Many columns on sheet - not all appear as options in a report?
Happy faux Friday! I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports. The problem is the latest report I'm trying to build, the 5 columns that I need to appear and provide data, are not showing up in the columns from which I can…
-
API endpoint for summary information reports
Currently when using the Smartsheet connector for Power BI, is not possible to grab sheet summary information reports, only reports based on sheet row line information. It would be very good to be able to gather information from summary based reports on Power BI.
-
Column Name Change Doesn't Break Report
I could be dreaming but didn't Smartsheet fix the issue where changing a column name breaks reports? Did this get released and then rolled back or am I imagining things?
