-
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…
-
Contact Columns ≠ Consistent Data
The Core Issue with Contact Columns Smartsheet Contact columns are fundamentally not reliable because they don’t represent people consistently. The same person can appear as a name in one place and an email address in another, depending on user status, permissions, ownership, or whether the data is viewed in a sheet,…
-
Sum of values in a column within quarters
Hi All, I need some help. I need a formula for sum of values within one column but I need to count it based on completion date. For context I want to messure how many labels were completed withing Q1, Q2, Q3 and Q4 2026. In my sheet is column with total amount of labels per change and another column has a date of…
-
Automation emails not sending consistently to some contacts
I'm running into a strange issue with automations and email delivery, and I'm hoping someone can clarify how to fix this. Setup: I have a Smartsheet form with: A required “Your Email” field (Contact column) Several hidden Contact List fields populated automatically Automations use “Send to contacts in a cell” Submitted…
-
Roadmapping with data living in SmartSheet
Hi all - Currently some functional areas of my organization are doing roadmaps similar to the image attached for their leadership. There's a desire to have the data for these roadmaps live in SmartSheet and push towards report automation. They really like the condensed view with multiple items in a lane (vs rows on rows on…