-
Keeping old and new data when needing approval/decline
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 both forecast and actual money spent per month (two separate columns per month). When a product owner adds a forecast amount…
-
Please help with a formula!
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 dashboard that shows 2018 vs 2019 year to date. I created the "YTD" column that shows the value of the last column that has…
-
Tracking Progress
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 have that dashboard, show (let's say) % complete on 12/31/18 then % complete on 1/31 etc. There is a need (want) in our…
-
Calculating Awarded Estimates
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 have been awarded to the total number we have quoted to date. I would also like then to check how many awarded projects have…
-
Trouble with including one row across multiple assignee reports
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 projects where the "Resource status" is set to "Active" (or "not Inactive" to pull anything where we may have made an error). This…
-
Unable to edit smartsheet items in Microsoft Teams
Hi all, I have a client that uses Smartsheet and will be joining our Microsoft tenant shortly. I created a Smartsheet account to familiarize myself with it and connect it to Microsoft Teams. I've created a tab and connected a sheet/report and it's showing me (View only) on Teams unable to edit. I granted a co-worker Admin…
-
Advice Needed to Optimize Workflow
Hello, I am looking to build a workflow for a review process in Smartsheets. There are multiple stages to this review process. For example, the item is submitted for Group A review. It must be approved by Group in order to be Submitted to Group B. What would be the best and most user friendly way to track who is reviewing…
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Pulling a report from multiple workspaces
We are already using personal workload reports to pull tasks from many sheets within one workspace (for us, project). I would like to build on this by seeing: 1. My tasks from two workspaces/projects in one single report, showing chronologically 2. Tasks from my personal task list sheet within that report too Bearing in…
-
Dashboard information depending on a selection
Hi, I just began using Dashboards and I have a question I´ve not able to answer. I have a project portfolio and several projects. The project portfolio is a centralized Smartsheet and its related to all the individual project smartsheets. I´m trying to build a Dashboard where you can select one of the projects of the…