I have a project schedule with multiple levels of parent rows. In the Duration column, the 2nd and 3rd tiers of parent rows do not subtotal the children underneath them. Is there some other setting or…
I'm trying to take a spreadsheet and present it in a way that has one row for each category of item, and then multiple cells across that row to represent the emails sent in that category. This is a ca…
I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have…
Hi - i have weekly meetings scheduled for the duration of a ~2 yr project and I'd like to use a SS dependency from the kickoff and a FF dependency from the last work item to set the duration of the we…
Hello, I added a date column to my report to show the actual date in the Dashboard but for whatever reason, the Dashboard wants to display the Gant view only for the date column. Can I turn the Gant v…
Hello! Smartsheet newbie here:) I was trying to use a simple SUMIF formula to calculate the total number of days for a specific field. For example: I want to add all the days or duration for all proje…
Hi, I wonder if someone can assist me. I am running schedules for construction projects with predecessors (Finish-Start relationships) set up. If myself/or another employee change the actual start dat…
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the ga…
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using f…