-
Automatically Create Report with Single Row Data?
Hello, Is it possible to use Smartsheet to automatically create a single row report and mail a viewable link? Use Case is similar to getting a package tracking number where the end user can view realtime progress on it with the unique link/identifier Below is the idea I have sketched out, but I have not found a way with…
-
Export only new rows from form submissions to excel
I have been searching for an automated way to get this done. I have a pretty intense (for me personally) form that my coworkers use to track a number of things that I measure. I am pretty married to my sheet and have a number of automated workflows running with it as well. There are about 48 columns of data including index…
-
Create Report source sheets? - Merge with same primary?
Update: It works correctly but when I filter it shows the filter on two rows. Can I make it merge all rows with the same primary? Hi, I created a report and pick both source sheets. The source sheets have the same primary ID however not in the same order. After picking the sources sheets, I pick the columns I want, those…
-
How to align column in when grouping reports
I am grouping a report on a given column (e.g. column A) and showing all rows under that group. However column for grouping is still shoing a width which i wish to get rid of. as shown in below or in attched document. Equipment xxxxxxxxxxxxxxx Part 1 xxxxxxxxxxxxxxx Part 2 I have used xxxxxxxxxxx to show spacing only here…
-
Gantt view in Report
Hello, I have a sheet with the respective columns to be able to visualize the Gantt view. Everything works perfectly in the sheet. Sheet: The difficulty I have is that I do not want people to have access to the source of the data. My idea was to create a report to visualize the Gantt view. This worked, half way. In the…
-
Dashboard/Report to show status change in last 30 days
Hi, I'm looking to be able to show on a dashboard a chart and detail of projects that have had a status change (RYG) in a given period of time (last 30 days). It doesn't appear that reports allows to filter on that type of data. any suggestions? Thanks! UPDATE- solved via Automated work flow using an added date column, and…
-
Why Can't I Check a Checkbox in a report?
I haven't had issues with this in the past, it suddenly is no longer working. So weird. I have a report that has 4 columns that can be checked / unchecked. Today, 2 of the columns are allowing me to check/ uncheck while in the report, (which will update the sheet that it pulls from), and the other two columns are unable to…
-
Introducing a new report builder plus grouping and summary for reports
Hi Smartsheet Community, Starting today, you’ll see some changes in reports, with the release of a new report builder plus the addition of two top customer-requested features that help you create more powerful and informative reports: grouping and summary. The new report builder replaces the previous “where, what, when,…
-
Visual grouping of data - input requested
Hi, looking for suggestions/tools on a way to show data visually grouped ideally without using parent/child relationships. e.g. if 5 initiatives were all tied to one larger objective, I'd like to only reflect the objective once (vs. in each row), with the 5 initiatives shown to the right. I know the calendar app offers…
-
Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following: there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage. Team 1 = Stage 1, Stage 2…