-
Is there a planned development / release date for % of resource to impact scheduling?
I.e. an effort based as opposed to duration based scheduling? At this point, I feel like I am doing all the scheduling work, and Smartsheet is only providing some reporting features. Standard PM methods would be assigning a resource to a project on a percentage basis (common in real world) and let the tool determine…
-
Project light status, Entire Row format & due date
Hi: what would be the formula for the following: project light status | Start Date | Proposed finish date | Finish date | Complete G 1/1/2015 2/10/2015 2/10/2015 complete R 15/1/2015 2/10/2015 3/15/2015 overdue/ At risk in both cases, Start date is pedecessaor to Proposed finish date and Finish date. So when we have a…
-
User Management and Contact List type
Good morning, If I am understanding this correctly, the User Management is what the Contact List type draws from to populate names. Is there a way to create different groups within the User Management area? For instance, I'd like to have two separate lists so that I can have two different Contact List types in my sheet.…
-
Formula's for [Start Date] column when dependencies are enabled
Hi, I am currently trying out Smartsheet in order to decide if we will be able to use this at our company or not. I'm using the construction timeline with gant chart template. I would like to add project management fee payment dates as milestones. Payment #1 linked to start of the project -> OK, no problem Payment #3…
-
Is there a way to hide a completed row (% Completion Column) in a project?
Using a project smart sheet with Gantt functionality, I would like to be able to hide competed tasks in the project sheet. It is used for production scheduling so the once a task is completed it is not needed to be viewed again unless desired. Note... predecessors are used so deletion of the task is not desirable.
-
Initial Setup Assistance: Hierarchy Req- Multiple Clients, Multi Projects, Multi Tasks
Before I get to it and go crazy generating all my works, can you please offer assistance in the best way to set up SS for my needs. Essentially, I want to be looking at one project at a time...my trials have left me with multiple tabs across various projects and clients, it gets confusing. If you are familiar with OneNote,…
-
See summarized duration/ % for header tasks
I have created a master sheet that links all my project gantt charts. Unfortunately I cannot see the summerized totals - is this available as an automatic function? I've been manually typing it in, but I'll have a lot of projects so this would be great if it was automated!
-
Production/Manufacturing/Importing
Hi we do alot of importing of containers and production/manufcaturing jobs is there a smartsheet that we could use to have all container imports in one place? what would the best template be to use? It would be easy to use one sheet for each but we really want to have it all in one place if possible?
-
Smart Sheet Real Time Timer
I am looking to see if a timer function can be added to log accumulated hours and minutes on a specific task your working on real time, for aiding invoicing, and/or assessing daily/weekly productivity over a range of tasks. Alternatively if a macro or VB script could be linked to a sheet for the same purpose?
-
Travel approval workflow
I am looking to make a workflow for travel approval . As the request form should be accessible for all employees I would like to use a webform. Approval shall be done by the Project Manager if travel is project related or the respective Line Manager if it is for non project travel (training, conferences,...). The Project…