-
Successor tasks have mysteriously changed to start the same day predecessor ends
While reviewing a timeline created several days ago I realized that successor tasks are suddenly starting the same day predecessor tasks are ending. For example, Task A ends on 4/10/26 and task B begins on 4/10/26. Previously, task B would begin the following day, in this case 4/13/26 because Saturday and Sunday are non…
-
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…
-
Adding YTD totals without using Sheet Summary fields
I have a sheet the tracks manufacturing operations. Each year, I need to summarize YTD totals from the sheet. This is resulting in many sheet summary fields each year. As time goes on, I will run out of the limit of 200 fields. Is there a way to automate any of this, either with automation or having information go to…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
Unable To Create Project Using Control Center
Hello community! This is my first time trying to use Control Center so bear with me. I've been tasked with creating a solution within Control Center to provision new projects. I have my project sheet, I have my intake. I created a program and blueprint on the Control Center side. It references the intake sheet and a…
-
Merged: Dynamic View Grid Lines / Column Freeze
This discussion has been merged.
-
Dynamic view time-stamp issue
I am set up in CET, and I set up a dynamic view where the time stamp column (time created) in the sheet is transposed to the dynamic view with a +6 hrs. This is kind of inconvenient… is this an issue that can be resolved? e.g. 12:01 pm appears as 18:01 in the dynamic view vs. 12:01, 11:40 am appears as 17:40 in the dynamic…
-
Control Center Links and updating from report
I am using control center to create new projects and folders and linking to a Summary sheet. However I want to be able to create a report from the summary sheet and make updates to fields that will post back to the summary and the project. Is this possible? currently no matter what link option I use in the profile setup it…
-
Report Filters Not Working
I have created a report and added the sheets from the workspace. I have created filters to pull in only the projects that need "approval to post." The conditions are set so the task that must be submitted before a project can be approved is submitted, and the task to approve the project to post is blank (not approved). I…
-
Bulk add columns across multiple sheets and support viewing two sheets side by side
I manage a large number of sheets (100+) that share the same structure, and I often need to add one or more columns across all of them. Currently this requires opening each sheet individually and adding the column manually, which is very time-consuming. It would be extremely helpful to have a way to apply structural…