-
Reporting based on % of work
I need to have an initial graph of the amount of planned work schedulled for each week of the project. The "X" axis will have each week and the "Y" axis the % of work to have done. I am sharing a graph as an example. The blue line will be the planned baseline project. The red line the real work on a weekly basis. Any ideas…
-
How can I delete recurring e-mails?
I have two recurring e-mails that I need to delete due to a personelle change. How do I do that? They are from a report and when I go to e Send or Share Sheet, Send as attachment they show up on the right but it won't alow me to select Edit Recurrence or Delete. Thanks, Jamie
-
Parents on Reports
Is there any way to NOT have the parent line on the reports? Because it doesn't follow the hierarchy like on the gantt view, it makes the calendar view of the report very confusing. I know when your going to print something it gives the option to include the parent or not. Inquiring minds want to know. Thanks,
-
Modify an existing report sent via Email with Attachment
One of the databases we built using Smartsheet allows us to facilitate communicating with various people from different functions. That means we have to create different reports that filter some of the data. We use the "Email Send as Attachment" feature to set up recurring emails that are sent to specific people at…
-
Repeating Columns in Reports
I have a combined report that is pulling information from 10 different smartsheets. The columnar information is the same from each of the smartsheets. For some reason, 1 column repeats on the report for each sheet. Lets say I have 10 seets from 10 different people. Each sheet will report that one Column (lets call it the…
-
Reports
I've created a report to pull data into a smartsheet based on a checkbox field. The field is called Dashboard and the report criteria searches all smartsheets and work spaces looking for this field and if it's checked it pulls data into the report. There is one smartsheet that has items that have no check in this field…
-
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
-
Is it possible to default to the calendar view rather than the grid view?
I set up a conf room reservation system using a report on top of a smartsheet. I've shared the URL with end users but sometimes when they follow the link it displays in grid view when I only want it to display in calendar view. Sometimes its correct and sometimes not which is causing headaches. Is there a way to force one…
-
Printing a row & consolidating data
Hi, I use rows for individual marketing campaigns and tracking progress across columns. When I close a campaign, I'd like to print off a report of all of the data in that row. Each job has about 55 columns of data. Is there an easy way to print off a report of all of that data without it being presented in a row, visually?…
-
Complaint / Poor Design: Blank Reports
I've just learned reports shared with users who are not also shared to the sheet (or sheets) that contain the base data cannot see the reports due to "security issues". This is - in my opinion - a seriously poor design. If Smartsheet can't secure a sheet / report relationship in this manner, what's to say anything can be…
