-
MS Project vs Smartsheet connectivity
I have a project that is run in MS Project (Desktop) on clients SharePoint, which we also want to have in our Smartsheet account so that we can track the progress and allocated resources, without duplicating efforts on updating both. I have found this can be done via Data Shuttle (which supports desktop version of MS)…
-
Project Cutover Planning
I have been working to transition my Excel based cutover plan to Smartsheet. I have read the posts about the challenges with Date and Time and having the ability to calculate duration with these challenges. Has anyone identified a truly viable option to track tasks at the minute, hour and day level for both child and…
-
Creating a KPI Metric for a specific Project dashboard then up in the Portfolio Dashboard
I'm trying to create a KPI for Client attended meetings. We have 32 weekly meetings and a sheet with a Yes or No for Client attendance. I created a sheet but want to add a widget in the Project Dashboard then take that up into the Portfolio Dashboard. I would like both to be a colored percentage pie chart for Yes and No on…
-
Use Cases for Smartsheet Bridge or AWM
Hi Everyone, I've been working to bring my PMO into Smartsheet for our documentation over the past 18 months. My team has made a lot of progress with using sheets to track assignments, out of office time, and the progress of change orders, but we're starting to run into some roadblocks when it comes to scaling our…
-
Scope Of Work
i see Scope of work downloads for free with trial. i am pro level paid account and cannot find the scope of work templates
-
Dashboarding Annual Calendar: Best Practice
Trying to develop a calendar/dashboard to reflect the major milestones of all projects happening in the PMO and having a difficult time! I haven't been able to find a dashboard visualization that easily displays all projects at a high level with callouts for project milestones.. I tried a timeline widget (see image below)…
-
Does anyone have a project plan used to bring Smartsheet into your company?
Looking for a project plan that I could use to bring Smartsheet into my company. We are going to be needing SSO Control Center Building Templates for Control Center Building out connectors (mainly for Azure DevOps) Creating Reports (for projects but also for users to see open tasks by project assigned to them) anything…
-
Assistance on Calculating Target % Complete & Understand %Complete calculation
I need assistance with understanding how the % Complete for parent tasks in Smartsheet. Specifically, I’m trying to understand how Smartsheet computes these percentages at higher hierarchy levels when using formulas. Even though the Actual%Complete and my calculate column of "Developed %" values for child tasks are…
-
Several Master Sheets vs Just One
Hi Smartsheet community, I would kindly ask for your best practices/recommendations to handle the following situation in a large company where we are using the PMO Template for managing IT Projects. When we built the solution, we started with two main files: DataSource → List of demands and details, sourced from our…
-
Board View card order
We're running sprints every 2 weeks and have a lot of cards in each lane in Board view. I manually set each card in a particular order from top to bottom in each lane since there is no current Sort option. Randomly, Smartsheet will re-order the cards! I can't figure out why they are getting re-ordered, what is causing it,…