-
Recurring PDF attachments views - Gantt and calendar
Hi all, I have two views that need to be sent as a PDF on a biweekly basis. I'm looking for the following: 1) Calendar view export that shows launch dates within the current month and next two months - I'm aware I can set report parameters to show everything launching within the next 90 days, but I want to be sure that,…
-
Creating a Milestone
I would like to create a milestone where it is within a timeframe I decide to setup. For Example if I put the Start Date as 5/15/18 and a target date of 5/23/18 how can I go about doing this so we can see a milestone.
-
Saving and exporting
I am a new user of Smartsheet with some questions: 1. Can we save the project plan on a local storage device? 2. When sent as Excel, only tasks, dates, and duration of the task are sent. How can we send the complete view showing the days and weeks on which the tasks are marked? 3. Can we work on the file off line? Thx.
-
Populate Dates Between a Start Date and Finish Date
Hi, I am trying to create an element of capacity planning for the company i work for, and am having issues with the start date and finish date. I have a master production planning sheet which has a basic start date for the job, and a finish date for the job. This shows it nicely on the gantt chart and all the days that are…
-
gantt chart - dependencies that are not necessarily SS or FF (or any other combination)
I have a project where Activity A is anticipated to run for a month. And Activity B starts around the same time, maybe a little later (start date is independent of A).. however B can NOT be closed out until A is complete.. AND B has a hard stop due date. how do I set THAT one up? cuz I don't want B to automatically shift…
-
Calendar View
New to Smartsheets but I've created individual project sheets and I've taken key production data, specifically dates and linked them to a Master Production Schedule sheet. I've added the customer name as the parent and each stage of production as a child which allows me to see customer names and all of the steps in…
-
Gnatt View print
Dear All, I have a quite a large program plan. To have a level one plan, I have a column with a check box to indicate what needs to be shown in the Level 1 plan. On filtering the Checkbox the Gnatt Chart view shows the dependency links, however when I export the same to PDF view the dependency links disappear? I have tired…
-
Highlighting/Colouring Sundays in Gantt Chart
Hello, I want to colour all Sunday columns in a different colour than Monday to Saturday in my Gantt Chart Just like in the following Image; there are the Saturdays and Sundays with a grey background. EDIT: Okay, I got the issue. I also highlighted the rows of the main-tasks and its child-tasks in several colours (Task 1 +…
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…
-
Gantt Chart Revenue Forecasting
I've built a sheet with all of our active projects and am wanting to predict revenue. I am wondering if I can add expected revenue to milestones in a gantt chart and have it report monthly expected income as a report or on the chart itself somehow? I really just need a monthly total of expected revenue as I pile more and…
