-
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 %…
-
Regaining Access to Data After Having to Reinstate Smartsheet Subscription
I do not use Smartsheet but am the admin for a company that uses it daily. We had a former employee cancel our company plan when the annual invoice inadvertently charged his credit card. We have since reinstated the plan; however, my colleagues are unable to access, edit, view or otherwise do anything with their data and…
-
Changes made to column titles
Automated flow when a cell or row changes exist already. I want to notify a person when the title of a specific column changes as it will effect dashboards that refer to the column title.