-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
"WBS Helper Columns->" column
Does anybody know what the "WBS Helper Columns->" column does in the Project with Work Breakdown Schedule (WBS) template? Is it just a helper column where a function could reside, or does it have an "Off the Shelf" purpose?
-
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.