-
Dashboard reports
Does anybody know how to autosize reports is dashboards, for example if I have 4 rows to show all 4 rows without having to resize the dashboard or if I have 10 rows to show all 10 rows?
-
auto resizing widgets in Smartsheet reports
Hi there, I'm creating dashboards and they are working well, but one annoyance is that there are many occasions when the data displayed in the report widget, is bigger (usually longer) than the widget frame. Is there a way to set the widget to auto size based upon the number of rows brought back? Many thanks, Matt
-
Count if formula and task progress
Hi, I've been trying every way possible to set this up so hoping someone can assist-- I would like to create a dashboard with a pie chart that shows how many tasks with a due date for the past 30 days from a sheet are done or incomplete. This seems simple enough, but Smartsheet keeps telling me I can only use numeric…
-
Sheet/Report Limitations?
Hi everyone! I was wondering if this scenario is possible for sheets either using formulas or commands. Example, I have 3 sheets (pipelines) that lead to multiple reports. I have jobs ranging from 0-100 (intervals of 20) percent probability(of selling/sold) in the pipelines. I currently have reports that group the…
-
Report Enhancement Request
I would like to be able to reference filter criteria for reports from a single top level cell. My project and workaround/issue is below: I am in the manufacturing business. We have machining lines that have a number of operations: ill say on average its ~20 operations. Each operation has an operator that at the end of the…
-
Tracking edits of one column only
I'm trying to track when end dates are changes in the project plan. I've added a system-generated column that will show when a whole row is modified, any way to limit that to one column? I need reporting capabilities that aren't possible with the activity log or cell activity functions. It also would be great if there was…
-
Average of a drop downbox item
Hello, I am currently working on a project that involves a Dropdown box that has 3 options, Not Started, In-progress and Completed. However, I would like to get the average status of the project, and the the formula I am currently using doesn't seem to be working properly so I was wondering if I could have some help. This…
-
Looking for some guidance: need recommendation on the best template to use with client to track feed
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insight, feature requests and help requests for a 30 day product evaluation period. I'm not expecting to find the EXACT template,…
-
List of Automated Reports
How can I list my automated reports? I've got a number of automated emails with report attachments going out to a wide audience on a regular basis. I want to tidy them up and reduce noise and redundancy. I'd prefer to avoid scanning through all of our reports manually if there's a better option. Thanks for any advice, Josh
-
Summary Cells & Adding Rows
If I understand Smartsheets correctly, all formulas must reside within the sheet where the data exists meaning, if I want to display a metric or a total on a Sights Dashboard or Report respectively, I cannot. So, what do you recommend I do to create summary cells on a sheet where rows will be continuously added?
