-
How to prevent entire Gantt timeline from shifting when updating activity dates? (Float reduction instead)
Hi everyone, I’m looking for some guidance on how Smartsheet handles float and dependencies in a Gantt project schedule. I’ve built a Gantt plan with several tasks linked through dependencies, and I can see the calculated float/slack between activities. When a small delay occurs on one activity, I update the start date to…
-
I am stuck in view mode but I have editor access level how can I be released from view mode and back to editing the sheet
Hello I share my sheet with a fellow member to add and do task to update this sheet they were editors to the sheet but something happen where now they can only view the sheet and can not in put any information to the sheet what I erase them from the group and updated the app but once he got access to the group again he…
-
Status reports
Has anyone figured out how to easily see overdue tasks in RM or how to pull a report? Side question: Are we any closer to have RM statuses sync to Smartsheet?
-
Mistakenly Cancelled my Business Plan
Hello good people. I cancelled my Business plan by mistake, before transferring ownership to other account. Now i have enrolled and paid again i still cant edit my workspace and sheet as they are on view only. Please help me on the way forward.
-
Sum values from child rows automatically with formula while allowing manual data entry into child row cells
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…
-
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
-
Seeking ideas and best practices for centralized intake form
The communications and marketing functions at our company recently all merged into one large team. We're now working on creating a new, centralized intake form to capture all incoming requests. However, several functions (e.g., employee comms, graphics, events) have existing Smartsheet forms that they've been using for…
-
👋 Hello from Kentucky! | IT & Manufacturing PM
The Professional Side: I’m a Project Manager in the Manufacturing sector, where precision and timing are the heartbeat of everything we do. My journey started in general project management, but I’ve found my true "geek gear" in the IT and Security space. I’ve made Smartsheet my "single source of truth" for keeping…
-
Portfolio Gate Reviews
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…
-
Count % Completion of Checked Items by Each Sub Project
Good morning Smartsheet Community, I am trying to put together a grid that captures the percentages complete broken down by individual areas of a project. Below are the variables I am trying to capture Percentages To Capture Power Installation % Data Installation % Millwork Completion % Configuration % Installation %…