-
How can I share a report to an user without sharing him paper, source of report?
I would share some data in a report with an user but I do not want share with him the paper, source of report. The aim is to use report as a tool able to visualize data for all users and to track and modify data on a paper used only by our project managers. Thank's you
-
Search on Dashboard
Any suggestions on the following without using Dynamic View: Dashboard has a report Search Box where a user enters data that return the list from the report directly into the Dashboard thoughts?
-
Report - Filter on current user does not work
Hi, I created a report to filter on current user. It works with myself, but not for another team mate. She sees data assigned to me vs herself. Any idea how to troubleshoot / fix? Report as I see it (my team mate should see her name, but she sees mine) Filter on current users
-
Sales pipeline with sort (need child/parent row stays together)
I have a sheet that has child/parent rows and which I can sort by dropdown list order (see below pics) So here are my questions: 1.) how can I have a report where it only shows the current user AND that the child/parent row are together when sorted in the report 2.) I want the sort to be "sort by dropdown list", is that…
-
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