-
Join Formula with Dates - How to eliminate the time stamp?
I am using the join formula to combine the task name, start date, and end date into a single column that will be used for reporting purposes. The start and end dates are formatted to only show the date, not a time, however when I use the join formula, it's giving me 'Task Name -- ##/##/## 8:00 AM - ##/##/## 4:59 PM" and I…
-
Dashboard Gantt Chart - Visualizing Variances
Hi ! My Dashboards are meant to visualize high level information on my portfolio of projects. One key is visualizing the project duration on a Gantt Chart from Inception to Completion (Project Start to Project Finish Date), which shows as a single bar connecting the two dates. However, the Gantt Chart in the dashboard is…
-
Synchronise Team Member Availability between Resource Management and Smartsheet
I have team members with part time availability, as specified in their Resource Management profile. Smartsheet allows me to schedule tasks for the days they are not working - the sync to Resource Management then displays "100% allocated for 0 Days" - the 0 days is due to this being a non-workday for that team member.…
-
PMO Template-- Archiving Projects
I have begun setting up/ using the PMO template. I am wondering if there is a way to archive old, completed projects so my project-level folder stays organized but the data is still available. Thanks
-
Return checkbox column to initial state after project scoping is complete
I'm trying to figure out if/how I can return a checkbox column to it's original state once a user has completed scoping a project. I've tried just about everything and keep running into roadblocks given my level of Smartsheet knowledge. For context: I've created a project scoping sheet that contains rows for all…
-
Resource Management: Fix ‘New Assignment’ pushing out employee start dates
In Resource Manager, whilst looking at the Schedule to view new Managed Resources and their availability based on their start date set within their new employee profile… · Problem: When you click on the Available 100% > New Assignment and select an assignment, it pushes back the start date of that resource back by anywhere…
-
Diverse visual calendar options
I am working with a team of field technicians that are all within the same department, but often split into smaller teams to complete work. These teams are dynamic, meaning that of the 8 technicians, all are capable of working with any number of the others in any number of total technicians. I am trying to design a…
-
Multiple IF to get change in progress of Status
Hi, I want my Live Status column to change as the stage progress, For ex; if my Status LO is complete my live status column should get status change to "LO Complete" and when Status LO Lock (LDS R1) changes to "Complete" the live status should change to " LO Lock(LDS R1) Complete" and so on
-
how do I add a calendar view in a Dashboard?
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them to have any any interaction, just see it as a reference. Is this possible? Thank you. Jef
-
Smartsheets issue with Start and End TIMES - is there a way to utilize MS project to feed that info?
Hi! I have been using Smartsheets for the past 4 years, and I love this product; however, one downfall is there is no ability to have an auto updated Start and End TIMES down to the minute (not dates) based on predecessor. On my past project, this was no big deal; however, on my new project, I have been asked to track down…
