-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Gantt View has come to WorkApps!
Hi Community, We have to admit, not having Gantt view in WorkApps kind of limited the scope of its project management functionality. Fortunately, we’ve gone ahead and taken care of that. Our latest release enables WorkApps to support Gantt view in the sheets experience! App users can now build pages using this view and end…
-
Compiling a multi-department calendar/timeline
This may seem super basic, but I work in tandem with 4 different teams and need to construct a calendar/timeline for all of these separate departments. What is the easiest way to gather the information? Some teams use smartsheet, some use excel, but none have the same format and none really "talk" with each other - hence…
-
Lost all tasks in Gantt view
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
-
adjusting the way baseline columns generate
Hi, I would like to make it so if I turn on baselines, I can use currently existing columns for dates and variance, rather then having to generate new ones. The reason for this is so I can use those columns in pre-made reports that are consistent across all projects built from a template, rather than having to manually…
-
Display Multiple Dates as Milestone in Gannt View / Timeline View in Smartsheet Reports
Hi, I have a query regarding the display of multiple dates from different Columns (5-6 Columns) from a report in Gannt View / Timeline Row within a row. Basically, Gannt of Gannts showing multiple projects in each row showing multiple Dates i.e. Gate Review dates in same row.
-
Timelines basics courses?
Hi all, I’m looking to get more up to speed with Smartsheet timelines, especially features like Gantt charts, dependencies, milestones, and overall timeline best practices. I’ve already built out one sheet and understand the basics, but I’d love to learn more about the tips, tricks, and best practices that more experienced…
-
The "Master Program View" (Dynamic Sheet Aggregation)
Problem: Current Limitations Reports are "Flat" Lists: Current Reports can aggregate rows from multiple sheets, but they function as static lists. They cannot perform project logic (dependencies, duration calculations) across those sheets. No Cross-Sheet Critical Path: There is no native way to identify a "Critical Path"…
-
Aligning week number to financial year
Hiya, Asking this question again as I have still seen no solution here. In a gantt chart is it possible to align the week number with a financial year? In our business our financial year starts the first week of July - This however comes up as week 27, not week 1. Cheers
-
Lock A Specific View (so users can't switch to another view)
We'd like the ability to restrict a view in a report or in a sheet so that a user can ONLY view a sheet or report in a specific view (like Card View, Grid View, etc.) Example: Our team discovered Card View is the safest way to allow multiple users to have Edit access to a sheet or report while lowering the chances of them…