-
Importing ms project file on a weekly basis into Smartsheet; impact on RM?
Client requests project plan in mpp format. Company needs to use RM module to track timesheets, resource allocation, forward looking availability based on sales pipeline. Heard uncomforting stories about importing mpp into Smartsheet. I doubt the below will work; would appreciate support from the community: Based on mpp…
-
How can I reschedule all the tasks dates based on the last task done?
I Have a entire project but the date is fixed base on the lead time of the project. If i have a delay on a task, i need to see the move on the entire project in a new column, is that possible? In the image I have the columns "Planned start" and "Planned ending", the dates are fixed. Team is filling the colums "Real Start"…
-
Smart Forms Templates
Is there any Smart Forms Templates that can be used? I wanted to make a smart form that allowed the easy use of Contractor SOW form or something similar to it. I wanted to be able to have contractors fill it out and state their information such as, certifications relevant to work being completed, personnel on site during…
-
Project Templates
I am creating a system to manage projects within our core business. To fully manage the project I have several sheets, reports and dashboards. Some of the sheets are tied together with automation copying rows and recording dates. The multiple reports are gathering data from the sheets to be displayed on the dashboard. The…
-
Formula Help
I am looking to set up a formula where a status column gets automatically updated to a certain color based on the relationship of the % complete column and the end date column for each row in the plan. Examples of what I am looking for below. If % Complete = 100%, then Status Column = Green If % Complete < 100% and Target…
-
Merged: Tracking Users' Sheet Views, Edits, Shares... All Activity
This discussion has been merged.
-
Is it possible to reset only a part of the baseline date during the project ?
Regarding the start date /end date baseline function, I'm wondering if it is possible to reset the baseline date just for a part of my planning. For example, if I plan my baseline at the start of my project for every task and I activated the baseline function, and in the realization phase, the baseline of only one task…
-
Can I move a project provisioned through Control Center from one program to another?
I'm currently facing a situation where I have several projects that were provisioned under one program (portfolio) and already have significant work done in them, but due to some reorganization, they need to be moved to another program (portfolio). The projects follow the same blueprint, but I'm concerned that all of the…
-
Simultaneous Update of Project and Review Sheets, for Non-Existent Projects, with one form
I am part of a Solution Architecture department that uses Smartsheet to track project reviews. Our workflow involves two Smartsheet sheets: a Master sheet for basic project information (project name, ID, contacts, status), and a Review sheet for detailed review data (review ID, review name, review type, project name, and…
-
Proofing - Exporting Markup
Hello All, Is anyone aware of a way to export proofing comments and markup? Currently, I have to take screen shots of the file and the comments to compare with the previous version and use for archiving purposes. Thanks for the assist.