-
Timeline view is now available in AU!
September 29, 2025 Timeline view is now available for customers in the Smartsheet AU environment. This new view empowers teams to visualize tasks along a timeline and manage date-based work in real time, helping them instantly see the big picture and adjust details with ease. Learn more Environments availability:…
-
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
-
Missing column in Report if I use a formula
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?
-
Is anyone experiencing issues with Completion % not accurately rolling up to the parent row?
We use a change cell value automation to update the standard % Complete column to 100% when a task status changes to Completed. This used to work perfectly, however, recently we noticed that the % Complete for the parent row in our project plan (e.g., Planning, Execution, Closing) is not recognizing the cell update. Our…
-
Implement 'partial match' search on drop-down lists in Dynamic View so it works in same way as sheet
in a sheet - a drop-down list column with allow multiple values selected offers a 'partial match' text search capability so that typing words in the middle of a text string will result in a shortlist of options being shown. This is excellent. However - the same column when used in Dynamic View only provides an 'exact…
-
System to manage ideas into improvement initiatives
I'm trying to create a system to take improvement ideas logged in a sheet through a triage process for each business unit and then finally into improvement initiatives that will address multiple ideas. My idea is to have a sheet that sits behind, and the reports for each B/U for both the triage and initiative stages that…
-
Sheet View - board
Within the Board and card view - currently right now we can group the records by certain categories such as "status" which we choose. Is there a way to make "status" the primary view but in addition break it further as the secondary option by "application" thus for example under "in planning" we can see a separate column…
-
Sheet View - Timeline
Within the timeline view - when selecting "weeks" to show the data is there any possibility to create an extra filter which allows the user to narrow the results to 4 weeks of data only? (or a set number of weeks depending on the user needs). Currently i see more than i need and can be difficult to illustrate to wider…
-
Help Article updates September 2025
Hello Community, We’ve published new videos on these topics: How to use sheet settings in Sheet settings in table, board, and timeline view How to use filters in table, board, and timeline view in Filter your data in table, board, and timeline view How to set up a sheet in Create a sheet To view the entire catalog of help…
-
Dropdown List option to hide 'Select All'
If a dropdown list can have multiple values in a cell it adds an option to 'Select All'. There should be an option the in properties to hide this where selecting all values makes no sense.