-
Set Default View in a Shortcut Widget
When a shortcut widget in a dashboard is linked to a Smartsheet item, those links always default to the grid view of an asset (if it's a sheet). If you are trying to promote gantt, card, calendar, or the new Board or Timeline views of an asset, it would be great if the user configuring the shortcut widget had the option to…
-
Making a Gantt View with only working days (Mon to Fri, exclude public holiday)
Is there a way to remove weekend and public holidays from Gantt chart? I'm planning a project with long durations per milestone, I would like to see only working days in the columns; alternately, can I have the duration formula only calculate # of working days?
-
Count number of tasks by day to know how many workers are needed
Hi Everyone, Brand new to smartsheet and I have very little understanding of it's capabilities. I've built an extensive gantt chart with tasks going out over a year. When I manually count the tasks, I can see that I need anywhere between 2 and 5 workers on a given day based on the number of active tasks. As I continue to…
-
HELP - Creating dependencies but using start-date instead of lag
I am building a plan with my stakeholders, we have a number of sprint-based tasks that have dependencies. It is very painful to constantly use the 'lag' function for all of these. How can I:1. Link activities using dependencies so they can be visualised in the plan. 2. Allow me to put in a start-date for the successor…
-
Unparsable IF( & Gantt
I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to…
-
Merged: Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
This discussion has been merged.
-
General timeline for Gantt view
Hi Smartsheet technical team, Very often similar projects or recurring projects follow the same time schedule where specific dates are unnecessary. It will be good if the Gantt view can show a timeline without specific dates and that will give a general overview of the timeline to all stakeholders of the project. Thank you!
-
Representing Multiple Phases on a Single Gantt Chart Row
Hello Smartsheet community, I’m working on a project where I need to visually represent different phases on the same row of a Gantt chart. For example, I have a project that runs in three phases: Phase 1: January to March (Yellow) Phase 2: March to June (Green) Phase 3: June to July (Red) Is there any native solution or…
-
Merged: Representing Multiple Phases on a Single Gantt Chart Row
This discussion has been merged.
-
is "export gantt to image" completely broken?
The text looks terrible on the image when i select this option? I need it to be an image to insert into other documents.