-
Updated User Role/Permissions to allow Template Sheet Creation by ALL EDITORS/Admins/Owners
Allow Templated New Sheet Creation by ALL EDITORS/Admins/Owners. I understand restricting new grid/report/etc. creation WITHOUT A TEMPLATE to all Editors/Below. However, restricting Templated new sheet creation for Editors/Above defeats the point of creating a template to allow team based scalable project workflows. The…
-
Allowing the Lag days in the predecessor field to be elapsed days
I've run into this issue where by the days I want a task to lag by is an elapsed number. E.g. Predecessor 380FS + e90d. The elapsed day function works well in the duration field.
-
Merged: elapsed days as a predecessor lag
This discussion has been merged.
-
Form Option to Rank Drop Down Choices
It would really be helpful to be able to have a multiple choice grid option in a Smartsheet form. Several projects in my team which should have been a Smartsheet were built in google because this option wasn't available. I need a way for this to be an easy option in an intake form, without relying on update requests,…
-
Table View "Reference Another Sheet" Link
In Sheet view, when writing formulas like index(match()) or similar, there's the option to click on "Reference Another Sheet" to select a reference range on an external sheet. With the new Table View formulas pop-out, I am unable to do this. I am unable to use Table View until this feature is updated.
-
More efficient way to hide/unhide columns
Provide an easier way to hide and unhide mulitple columns. We have large sheets with multiple columns, and there are times when we only want to view a smaller group of columns. Currently it's too cumbersome to hide the columns we don't need and then unhide when we are done, so we just scroll back and forth to view what is…
-
Make REST API Calls with an Automation
It would be beneficial to be able to leverage Smartsheet Automations to make REST API calls. This has many potential use cases, but one I could see is adding users to Smartsheet groups when the are added to a 'roster sheet' in Smartsheet. It would allow us to use the full power of Smartsheet's API within easy to use…
-
Warnings when approaching functional sheet capacity
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
-
Native Secondary Axis & Mixed Charting
Problem: Current Limitations Scale Conflicts: Currently, users cannot easily plot two data series with vastly different scales (e.g., "Budget" in millions vs. "% Complete" in decimals) on the same chart; the smaller metric becomes invisible. Complex Workarounds: Users are forced to create "Helper Columns" (to manually…
-
Automated Dashboard Snapshots & History
Problem: Current Limitations Ephemeral Data: Dashboards are "always live." As soon as the underlying data changes, the previous state of the dashboard is lost forever; there is no native way to view "what the dashboard looked like last Friday." Manual Workarounds: Users must manually use snipping tools or "Print to PDF"…