-
Bringing Smartsheet to K-12
I have been using Smartsheet for a few years primarily focused on a I.T. PMO scope, however I recently changed into the education space supporting a K-12 environment. Though I am in the I.T. department, the project support extends to the entire campus and all departments. For those that have been in education with a longer…
-
Sum by Month in Report
I have a report created from 19 sheets - these sheets have delivery dates and project values. I want to sum by Month. See screen shot of what I have so far. I can't get it to sum, September, October, November and December independently. HELP
-
Why is % Complete not the same between Smartsheet and Microsoft Projects
I have two identical projects with the exact same data, but the % Complete in Smartsheet is 14% and the % Complete in Microsoft Projects is 4%. Which one is correct
-
Formatting, dividers, or symbols in Card View body
Hello Smartsheet Team, I'm reaching out to share an idea and ask for future updates, if possible. Our team uses Card View for sample requests. Each card contains many necessary parts, and up to 10 people always work on the same sections (cutters, sewers, coordinator, quality, etc.). The card length is correct and expected.…
-
Workspace Owner Wanting to Export List of Users
Friends: I'm a Workspace owner. I have accreted a large number of users as the project has expanded. Sadly, the only way to audit/update that list of users is through the Share Window for the workspace. Is there a way to export a list of users for a workspace? This is a real BEAR. Thanks for your help. Onward
-
Program Toolkit: How to rename program through control panel & Keep existing cell links.
I have several program folders with smartsheet templates connected to a blueprint, managed by Control Center. My question is this; How do I change the program name of a folder and its sheets while retaining all existing cell links? Additionally these programs roll up into other sheets for reporting and dashboards, These…
-
Planned % rollup formula giving higher % than % Complete
Hi Community, I’m trying to build a reliable Planned % column that rolls up consistently, so I can compare it against % Complete at the project and phase levels. Setup I created an Old Planned % column that calculates planned progress for each row based on Planned Start and Planned Finish dates: =IF(OR([Planned Start]@row…
-
Critical Path based on a release
I would like to see a critical path on a large project based on a release number. The critical path seems to be only available on a sheet basis. I can use a critical path filter that works great – but again works on a whole sheet. I was thinking about using a Release Number filter and then copying just those rows to a new…
-
Gantt Chart Display and Behavior - Open to today's date mysteriously gets unchecked.
After I have checked Open to today's date for my project setting, it gets unchecked in a couple of minutes. Is anyone else experiencing this? https://help.smartsheet.com/articles/765755-modifying-project-settings#toc-customize-the-gantt-chart-display-and-behavior
-
How to record a date in a gantt?
Hi, I have a question about the Gantt chart. I want to record a date (start date) when a row is added. This will ensure that when a row is added to the Gantt chart, the start date is recorded at the beginning of the Gantt chart, and the other dates are automatically calculated. Is this possible? Regards