-
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…
-
Collaborative and real-time editing
If multiple users end up editing the same cell without realizing, the last change that was saved overwrites the other. All editors should be able to view the current cell that is being edited and should be able to lock them as they continue to edit.
-
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…
-
Creating a formatted/merged email from a grid
I have a complicated workflow that I'd like to significantly reduce, in terms of time spent. Working from a standard grid, I need to format the email, pulling some summary information for a project and then adding specifics for each individual tied to each project. A few points: the summary information is currently in a…
-
Lengthy text value in dropdown not a pickable option in certain filters
Hi, I have a dropdown column in a sheet. The column contains 98 separate dropdown values. I've noticed that one of the values (the longest one) doesn't show in the list when trying to filter using the "is one of" or "is not one of" options. All other 97 dropdown values display. This is the name of the value that doesn't…
-
Distinguish Access Acceptors from Admins
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
-
SQL connector to data shuttle
If smartsheet can bring in SQL connector to Data shuttle, we can use this to bring in data from SQL which would be handy when we use sheets to track data and manage the changes
-
% Resource Allocation changing Duration
Is there a way that if you change the % Resource Allocation it changes the Duration of a task?