-
Export or Print Multiple Reports Through Action Drop Down
Anyone know of a way to batch export or print reports? Planning on running upwards of 50 reports and I want to be able to print through the actions drop down to capture all of them at once rather than opening individually and clicking print one by one.
-
Reporting on Linked Dependencies?
Hi, I have a program with 40+ project plans many of which have inter plan dependencies (with cells linking the dependent task or output from one plan to anouther). As part of my QA process, I want to create a report that will identify these linked dependencies in each project plan either as a sum total or listing out the…
-
Is there a formula/function to help count number of children assigned to specific parent tasks?
Hi all, I'm trying to put together a table that lists the number of sub-tasks (children) in each respective Workstream (parent) of a specific Project Plan, and also breaks these down into their respective Health Status (Green, Yellow, Red). I am aware that I can apply a "COUNTIF" formula and set the range to encompass the…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Start and end date line chart
Hi Team, Can anyone help me how can I create a line chart based on below information. I
-
Bring Task to a separated Smartsheet if due date
Hi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks that are about to get due. How can I do this? Thank you
-
Calculating daily and last 30 days averages based on form submissions
Hello, I am collecting daily form submissions and want to have a dashboard to report on key metrics from these submissions. See screenshot. Here's what I want to calculate: Daily average for columns Role, Identity, Technique, Quality of Day, and My Score Today. At the end of the day I need to see what TODAY's average…
-
Counting dates by week, months and year formula
Hi, I have a SmartSheet which logs enquiries. I need to create KPI report to measure the number on enquiries that are logged that day, this week, this month, last month, and year. Also a monthly running today for example Jan = 40, Feb = 50 and so on. Below is a screenshot of my Smartsheet and the column used for the date…
-
Can I create a report/Sheet that would capture all conversations on multiple sheets in a workspace?
I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?
-
Reports user-friendliness
Hello, A little bit of context: I have a central Sheet displaying data and gathering inputs to & from multiple stakeholders via individual reports. This sheet holds a number of workflows, is fed by several datameshes, etc. In theory I don't want users to be able to see data from other users. To do this here is the option I…
