Hello everyone, I am using Smartsheet to manage several projects, all on individual sheets, with a high level role up for managers. We are trying to create a report that goes through all of the projec…
Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all…
Hi, I am new to Smartsheet and I am trying to create a view for my team where I can see all of the tasks, across multiple sheets (projects), that individual team members are assigned. In other words I…
I use a Sight as a dashboard, so I created a report to pick up only entire schedule for each project. i.e. I have 5 "bars" in the report, represents 5 projects. And I want to show milestones with each…
Good afternoon, We have shared some reports with sub contractors that we would like them to be able to edit. How do we just let them edit the report and NOT be allowed to edit/access the sheet the rep…
We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent b…
I am looking to compare Year to Date numbers, and I'm having a hard time figuring out a formula to do so. I've attached a sample screen shot. At the end of the day, I'm trying to add a metric into a d…
Is there a solution that can be shared to assist me in sharing progress at intervals? For examples, I have a dashboard that lists the projects and the % completion, at any given time. I would like to …
I have a running list of estimates we submit. when we are awarded the project that column gets checked. im looking for a way to scan the entire column and report back the percentage of estimates we ha…
Hi friends, Having a bit of difficulty setting up a series of over/under reports. I'd like the report to pull any project with the employee's name matched in the "Resource name", and only pull project…