-
Support for Multiple Regional Calendars and Work Schedules in Smartsheet and RM
Businesses working across different countries often need to account for local holidays and variations in working hours/days/weeks, neither of which Smartsheet or Resource Management currently support. Resources identified located within a given region (via the Location field in RM, or some other method within Smartsheet)…
-
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…
-
Issue with Record Date automation.
Hi everyone, I’m hoping someone can help me with an issue I’ve been running into. When a user submits a form late in the evening — sometimes as early as 8:15 PM — the “Record a Date” automation occasionally logs the following day’s date instead of the actual submission date. Originally, I used =DATEONLY(Created@row ) to…