Best Of
Send an attachment as an attachment and not a link
It would be great to send attachments as attachments and not a link through the automated workflows.
Dynamic View Sorting Feature upgrade
Hierarchical sorting availability in Dynamic Views. Having the ability to sort by multiple fields would be excellent. The current sorting lends to things being in different orders for different users viewing the same dynamic view at the same time, and if you click the sort multiple times you will get different sort orders for the same thing. Ideally you would be able to have multiple fields of sorting capability in a hierarchy similar to how you have it in main sheets. image below is the sorting capabilities on the main sheet.
Aaron Saunders
Conditional Formatting on Sheet and Row Level
Dear Smartsheet Development Team,
I hope this message finds you well. I am writing to suggest an enhancement to the conditional formatting features in Smartsheet. As a frequent user of your platform, I have found that while Smartsheet offers robust functionalities, there are limitations in the conditional formatting options that hinder user experience and efficiency.
One particular limitation is the inability to apply conditional formatting to all cells on a sheet or an entire sheet at once. Currently, users can only apply conditional formatting to one column at a time. This restriction greatly limits the flexibility and efficiency of formatting large datasets, especially for users migrating from platforms like Excel where such capabilities are standard.
Given that conditional formatting is a fundamental tool utilized across various industries on a daily basis, enhancing these features in Smartsheet would significantly improve user productivity and satisfaction. Therefore, I propose the following enhancements to the conditional formatting functionality:
- Apply Conditional Formatting to Entire Sheets: Allow users to apply conditional formatting rules to all cells within a sheet or to entire sheets at once. This feature would streamline the formatting process for large datasets and improve overall efficiency.
- Bulk Conditional Formatting: Introduce the ability to apply conditional formatting rules to multiple columns or ranges simultaneously. This would enable users to format data more quickly and intuitively, similar to the capabilities offered in spreadsheet applications like Excel.
- Advanced Conditional Formatting Options: Expand the range of conditional formatting criteria and formatting styles available to users. This could include additional comparison operators, custom formulas, and more diverse formatting options such as icon sets and data bars.
- Conditional Formatting Presets: Provide users with pre-defined conditional formatting presets tailored for common use cases across different industries. This would simplify the formatting process for users who may not be familiar with creating custom rules.
By implementing these enhancements, Smartsheet can better meet the diverse needs of its users and provide a more comprehensive solution for data management and analysis. I believe these improvements would greatly enhance the usability and effectiveness of the platform, ultimately leading to higher user satisfaction and adoption.
Thank you for considering my suggestions. I look forward to seeing the continued evolution of Smartsheet and the implementation of these enhancements.
Controlling record visibility in reports using Smartsheet Groups
This solution allows you to combine the "Current User" filter and Smartsheet Group membership to filter records based on who is a member of a Smartsheet Group.
Solution overview
- Python
- Create scheduled task to run daily Python script that pulls all Smartsheet groups and group members and saves as CSV on SharePoint site.
- DataShuttle
- Schedule DataShuttle to load "Group-Member" CSV into "Groups" DataTable
- DataTable
- Create DataTable Connection to load "Groups" DataTable data into "Group-Members" sheet.
- Group-Members sheet
- The "Group-Members" sheet will contain a record for each Group-Member combination. There will be one record for every member of every group.
- DataMesh - Group names to Group Summary sheet
- Create DataMesh to transfer Group names from "Group-Members" sheet to "Group Summary" sheet.
- Group Summary sheet
- The "Group Summary" sheet will contain a list of every group and all members. There will be one record per Group.
- On "Group Summary" sheet use a Join Collect formula to gather all the group member emails into the "Group members - Text" field.
- =IF([# of members]@row <= 30, JOIN(COLLECT({Smartsheet Group List - Member email}, {Smartsheet Group List - Group name}, [Smartsheet group name]@row ), ";"), "Too many members to display")
- The Group members will appear as emails separated by ";"
- DataMesh - Convert member emails into Contacts
- Create a DataMesh to transfer the text group members into a Contact column called "Group members" on the same "Group summary" sheet. The text emails will be converted into Contacts.
At this point you will now have a automatically updating list of groups with their members as Contacts in Smartsheet. You can you DataMesh or cros ssheet references to pull the Group members onto other sheets using the Group name.
Tools required
- Computer to run scheduled Python query to pull Groups and Group members and save it to a SharePoint location
- SharePoint location to save the Group-Member list
- Smartsheet API access
- DataShuttle
- DataTable
- DataMesh
I hope this is useful to you.
Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology
Neil Egsgard
Re: Licenses and True-up confusion
I agree with rscott - why are there not any tools for admins to limit the number of users, or who can become provisional? The only explanation is that this is an attempt at a money grab, I have gotten a lot of questions from my management, specifically around looking for alternatives to Smartsheets because of the new licensing model.
Re: Include option in dashboard widget settings for open in new tab
Hello!
I just wanted to suggest an improvement to dashboards, specifically. It would be very nice to open up links to other dashboards/sheets/miscellaneous links in new tabs, or to at least have that as an option (ie- right click option).
I have noticed that some things open in new tabs, but it is very tedious to have to open a bookmarked dashboard, and then click that to go to a sheet, and it takes you there on the same tab. It means I have to keep clicking on my dashboard links to get to other sheets, and it takes away from the usefulness of dashboards as a 'one-stop-shop' by not having this feature.
I hope that this can be implemented soon, as this would be a major efficiency improvement! Thank you to all of your dev group for the continuous improvements, and for listening to your customer suggestions!
Taylor Mauzy
Generate formulas using AI in table view
October, 07, 2025
Table view now supports generating formulas using AI, previously only available in grid view. With this feature, you can quickly create working formulas in the formula panel without needing to master complex functions or syntax. Simply describe what you want the formula to do in plain language, and AI will generate it for you—complete with column references—right in your sheet.
We’ve also enhanced the experience by allowing you to switch between natural language and formula syntax input modes. This means you can either:
- Describe your intent in natural language and have AI generate the formula, or
- Enter a formula directly and have AI explain it to you.
Environments availability: Commercial US, Commercial EU, Commercial AU
Plan availability: Enterprise, Advanced Work Management
Subscription Model Availability: Legacy Collaborator Model, User Subscription Model
Stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Lekshmi Unnithan
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies and baseline reporting, I need the End Date to accurately reflect completion. I appreciate your consideration of this idea!
Amber Eakin
Dynamic View: Option to disable Details tab
In the most of the cases user just need to see report but not details tab, this can be confusing for user
Sheet - Format Cell Border
The ability to format cell borders with line style and color.


