Best Of
Activity on row level
Hi,
I would like to suggest that a option in the hamburger-menu for a row is added where one can see only the activity on the selected row.
Currently you need to download activity and manually filter on row-level.
support multiple milestone dates within a single row in Gantt View
Currently, Smartsheet allows only one Start Date and one End Date to generate a Gantt bar or milestone. However, many projects involve several key milestone dates such as approval dates, review checkpoints, testing completion, and launch readiness. These milestones are often stored in separate columns within the same row, but they cannot all be visualized simultaneously in the Gantt or Timeline view. This limitation requires users to create additional helper rows, duplicate data, or redesign their sheet structure just to display multiple milestone events.
The enhancement I would propose is a feature that allows users to select multiple date columns and display them as milestone markers on the same project row in the timeline. For example, if a project has columns for Gate Review 1, Gate Review 2, Design Approval, and Go-Live Date, Smartsheet should allow all these dates to appear as milestone icons along the same timeline bar.
This improvement would provide several benefits. First, it would significantly improve project visibility for leadership and stakeholders, especially in portfolio or PMO dashboards where multiple milestone checkpoints need to be tracked across many projects. Second, it would reduce the need for complex workarounds such as helper rows or additional sheets, improving data structure simplicity and maintainability. Third, it would enhance reporting capabilities by allowing reports to display richer timeline information without restructuring the source data.
Overall, this enhancement would make Smartsheet more powerful for project portfolio management, executive reporting, and milestone tracking, helping teams visualize progress and decision points more clearly within a single unified view.
I am doing Bidding unit process flow where this data will be handled by requester but there is bidding decision and should go for bid or not all these theing will be in 1 row bbut all the timeline and progress i want to see in same line if i have only 1 planned start and end date it will be difficult to configure this kind of work
Re: March Question of the Month - Join the conversation and receive a badge
Being able to have more people managing a Smartsheet group.
More interactive dashboard where users can apply filter to a chart (functionalities available in Tableau, Spotfire or PowerBI)
AntonioC
Automated Email Option to show only completed fields within a Form
We need to have the option within the Smartsheet Automated emails to only show the fields (from a form) that have been completed in the email. Right now, the email that the customer receives if they request a copy of their responses is exactly what the option within the Smartsheet automation should look like. Right now, we only have the option to show all fields, select fields, or the email confirmation text within the automation. This would be a significant time-saver for our team to only see the fields that have been completed in that automated email as we have to take that information and put it into various tools.
Re: Keyboard Shortcut - Conversation
Upvoted and commenting for visibility - admittedly I never noticed that there was a shortcut, but this would be a game-changer.
meagans
Re: Sheet Summary Formula to pull Month and FY based on Highest Value
Hi @Mad Ed,
I have a solution that should work for you. Create a new Sheet Summary field called "Table position" and use the following formula.
=MATCH([Most Sales in a Month]#, [FY2023]2:[FY2027]13, 0)
Next, create another Sheet Summary field for the concatenated value you are trying to find and use the following formula.
=INDEX(Month:Month, ROUNDDOWN(MATCH([Most Sales in a Month]#, [FY2023]1:[FY2027]13, 0) / 5) + 1) + " " + IF(MOD([Table position]#, 5) = 0, INDEX([FY2023]1:[FY2027]1, 1, 5), INDEX([FY2023]1:[FY2027]1, 1, MOD([Table position]#, 5)))
Hope this helps,
Dave
DKazatsky2
Copy a row into multi sheets picked
Is there a way to copy a row into multi sheets without doing it manually? Be able to choose sheets and copy a row of data into new sheets.
We have construction schedules build and want to add new tasks to sheets
Asset selection for sharing within the Workspace
Currently, in order to share specific sheets or reports within a workspace, each item has to be individually opened and shared with the user or groups. There should be a way of selecting the items/folders and sharing when you do not want to share the entire workspace. Doing this now will only share the whole workspace.
Breanna
Display filter count badge on Report-sourced views
I would like to request that the filter count number (the badge that appears next to the filter icon) be displayed consistently regardless of whether a view's source is a Sheet or a Report.
Currently, this number only appears when the view source is a Sheet. When the source is a Report, only the filter name displays — with no count badge. Since there is no setting to change this behavior, a product-level update would be needed to make this consistent across both source types.
Having this number visible on Report-sourced views would improve usability and make it easier to know at a glance how many filters are active.
Thank you for considering this request!
AVERAGEIFS implementation
Hi Team,
Is AVERAGEIFS something that might be added in the future?
Thanks,
Arpad
