-
Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
-
Gantt Chart - Is there a way to manually adjust a tasks start date without breaking dependencies ?
I'm creating a project schedule for the design and build of a new restaurant. The only concrete date that I know is the Tender date which is part way through the schedule. I filled out all the tasks and entered in the durations and predecessors for all the tasks. The problem is if I enter the date for Tender it only…
-
Gantt & Calendar Views on Reports
Thank you Smartsheet for the new feature allowing Gantt & Calendar Views on Reports! Best thing since sliced bread and dental floss!
-
Automatically add tasks to a web form populated row
Hi, I am fairly new to smartsheet and wanted to know if it was possible to automatically add a set list of tasks/ indented rows to a row that had been added via web form? I review sets of data that are submitted by multiple business unit and partner companies. The form this takes in always the same, and we have a set…
-
New in Smartsheet: Gantt and Calendar Views on Reports, Better Update Requests, and More
Smartsheet’s newest improvements give you more power to choose the level of detail you want to share, both within and outside your organization. Send a project rollup to executives using Reports, now complete with Gantt and Calendar Views, or share a single row to an external collaborator for a quick status update with…
-
Counting Number of Times a Predecessor is Used
Hi, Long story behind this one, I'll try to keep it short. On Smartsheet, the critical path tool isn't working for my sheet because our project has too many hard deadlines and we are not using enough predecessors; however, we need to be able to view a critical path, so I have accepted that I will have to create one…
-
Only print the milestones on my gantt
Hi, I'm new to smartsheet. My project is large. How do I print the grantt that only has the milestones and not all the data? Thanks Donna
-
Tracking the number of project work dates of multiple projects on one calendar
Hi, I am a new user of Smartsheet. I work for a Conservation Corps, where our contracts indicate total number of work days, and the actual work dates vary and move around based on our daily staffing and the sponsor's needs. It only matters that our projects are completed by the end of the fiscal year. I need to track total…
-
Copying excel worksheet cells to smart sheet gant chart cells
Hi, I have been asked to put my existing excel spreadsheet gant planning chart into smartsheet gant chart. Not happy as I am a total novice on smartsheet - but it is failry intuitive even for an old boy like me. I have figured out 'zooming' - it's not there.- not happy about that. So I am trying to copy a cell or set of…
-
Cost Data Not Exporting to Microsoft Project
I am a hardware engineer. My project engineer starts by handing me a Microsoft Project file so I can fill in the details of how long each task is going to take and how much cost will the labor and materials will be. I prefer importing the project file into Smartsheet so I can easily arrange the trench work and subsequently…