-
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
-
Automation won’t stamp “Last Changed” date when Status is formula + linked cells
Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets. In my Master sheet, the Status column is a formula. The fields that drive that formula are not manually edited…
-
Pause sheet sharing without having to re-share
I could not find a previously submitted request, so apologies if this is a duplicate. It would be very nice to be able to pause sheet sharing temporarily (aka Check-Out the sheet) so that updates can be made without other users logging into a work-in-progress. I manage several complex schedules and budgets, and constantly…
-
Gantt Chart Dependency Number Scaling When Zooming Out
I have been a Smartsheet subscriber for many years and use Gantt charts extensively for construction, fit-out, and engineering project scheduling. One recurring issue significantly affects productivity when reviewing project schedules with predecessor relationships. When zooming out on the Gantt chart to see the overall…
-
Tracking & Reporting on Project Hygiene
Hi All! I am starting to explore the possibility of tracking the "hygiene" of each project being managed by our team. We have a control center solution so the artifacts all of us on the team are consistent/templatized and capable of collecting data for a rolled-up portfolio view. So I'd like to be able to leverage that to…
-
Balancing governance and flexibility as Smartsheet adoption scales
Over the past year, I’ve been building Smartsheet systems in a multi-partner environment supporting project management, reporting, and operational workflows. As adoption has grown internally and across partner organizations, one challenge I’ve been thinking more about is balancing governance and standardization with…
-
% Complete Column Appears Broken
The screenshot shows an assignment I am working on for an online class. I have a question about the lines highlighted in yellow. The "% Complete" column is supposed to show a calculation of the children's done percentage, I think. Am I understanding that correctly? If so, the Campus & Grounds line (NPI-052) showing 51%…
-
Resource Management - Resource Cost Rate
I run a Professional Services business, and we are currently leveraging the Resource Management module for capacity and forecasting. We have created ways through formulas and sheet templates to account for cost rates, we would love a more systematic approach much like the bill rate function already present. A resource cost…
-
Post Dashboard Demo Questions
I always get the same question after I do a dashboard demonstration. 😂 "How do I export this to Excel?" What are some questions you get after demonstrating a Smartsheet dashboard's capabilities?