-
Streamlining Automation Requests/Form Options
My team is looking to use Smartsheet capabilities as we continue building an dashboard for tracking KPIs across various project initiatives. Each initiative has its own row in Smartsheet, and we've included the initiative owner in the corresponding column. Some initiative owners are listed for multiple initiatives. We're…
-
Construction Phase Count Formula
I'm trying to count how many projects are in the construction phase each month using this formula: =COUNTIFS({Master Project List Range 1}, "2 - Construction", {Master Project List Range 2}, <=Month@row, {Master Project List Range 3}, >=Month@row) It works, but I want to make sure it's also counting projects that are…
-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
'Save as New' no longer an option
Hello 😁 I used to be able to duplicate a folder by right clicking it and selecting 'Save as New'. This is no longer an option. Is there a workaround I can use to duplicate a folder? Am I missing something?
-
Best way to visually separate different phases in a Smartsheet tracker?
Hi, I often build trackers for workstreams that move through a process or lifecycle. Where these involve distinct phases, I’d like a clearer way to visually separate each phase within the sheet. At the moment, I’m just using coloured columns/lines as section breaks, but it doesn’t feel particularly clean or optimised. Does…
-
Critical path not showing in Gantt nor list view though dependencies are enabled
i have dependencies enabled in my project, all start/end/durations populated, and critical path button selected, but critical path is not showing in gantt view nor list view with critical path filter
-
Report adding and removing sheets
I have a report that consists of 27 sheets. Shared sheets and report with 3 people. These 3 people do not have the ability to add or remove sheets in this report. Is that normal? I would like for them to remove sheets as they complete a project. Attaching an image - the selection option is grayed out for them.
-
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…
-
Smartsheet equivalent to a popup window or pivot table?
Is there anything like a pivot table in the smartsheet ecosystem? I am looking for a solution that is somewhat like a sheet reference, but perhaps saves the time of double entry? Case in point: those of you that use Concur travel or something similar, how do you organize the data and make it retrievable but also something…