-
Reports consistency : include new sheets automatically
Hi I plan to have regular sheets created in a workspace(same structure) over the year. I want to use a report to consolidate all of these sheets in one place.I've put my sheets so far in a dedicated folder in this workspace. In the report builder, i pointed to this folder so i was hoping that any new sheet in this folder…
-
Report builder
Can i supply an input parm to run the report against a column and just extract the row/s that match the value in my input parm?
-
Best way to report a top of funnel of requests metric
Hello, We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you…
-
Conditional: If one child is closed or past due for approval, entire hierarchy/project is closed
I have an approval request setup in my sheet, and an age column where I am tracking the number of days since the approval request was sent out. I need a method to mark the whole project tree "Closed" if any of the children's requests for approval's "age" is over (2) days
-
How to create Report/Chart/Sheet for overview of many?
We have a Sheet for every project. Every Sheet is basically a checklist. The checklists are similar but wording and order of the tasks are different. I want to create something that will bring in just the "Completed" checkbox and the Primary Column of each Sheet/checklist so that the overall status can be easily seen. How…
-
Formula issues
Hello, I am experiencing the following issue: In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. If date is lacking in the respective column, other value options are either a blank cell, or a status "Overdue". What I am trying to achieve is count how many times in…
-
Feature Request - Edit Scheduled Report Send Email
Under Report > Send as an Attachment it is possible to schedule a recurring email. It is also possible to edit the recurrence deliver options but not to edit the email itself. You have to delete the recurring email and start over. Could we please have the ability to edit that email message? Thanks, Nick
-
Pulling text through from other sheets
Hi I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score). The risk and issue Log have a text description (there is a risk that....) and a risk score (5). I understand cell linking but this won't work as the top 5 risk and issues will change on…
-
Exporting History Data
I would like to export history data from an existing project, and tabulate the history data in excel. For example, I would like to see how finish dates have changed over time, for hundreds of rows, over the course of a project that has already finished. Is there a functionality to export a cell's (or selection of cells, or…
-
Reporting and dashboard help
I have a smartsheet containing work experience for every person in our company. The rows go something like this... * Steve Smith | Project Manager | Company A | 2.5 years | etc... * Steve Smith | Project Manager | Company B | 1.5 years | etc... * Steve Smith | Project Coordinator | Company B | 5 years | etc... * Karen…