-
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…
-
Not enough space in the cell for my notes
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
-
Displaying multiple time periods in Gantt view
Is there a way to display multiple time periods in Gantt view? Example: you have staff members that are your primary people, and they are contracted for 4 months, and then secondary or "fill" staff members that sit in when the primary is away on sabbatical or similar break. Idea here is that the gantt bar on a given row…
-
how can i overlap 2 tasks.
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…
-
Public links to sheets in automated emails?
I am trying to send non-Smartsheets users information on forms. I know I can create a publicly accessible and editable link for the overall sheet/form, however, when I set up automated emails with links to the forms, the links to sheets/rows still require a login. Is there any way to get around it so that emails sent…
-
Incremental Baselines & Dynamic Baseline Linking
Problem: Current Limitations Destructive Updates: Currently, snapping a baseline is a global action for the entire sheet. There is no way to baseline newly added scope (new tasks) without overwriting and erasing the historical variance data of the existing tasks. Manual Data Entry: Users are forced to manually copy/paste…
-
Batch Sheet Creation from Template
Problem: Current Limitations Manual Repetition: Provisioning a large project (e.g., 50+ distinct team sheets) currently requires manually executing the "Use Template" or "Duplicate Sheet" workflow 50 separate times. Time-Consuming Setup: There is no native bulk-action to instantiate multiple files at once, creating a…
-
Native Burnup Charts with Automated History Tracking
Problem: Current Limitations Complex Setup Required: Creating burnup charts currently requires advanced formula knowledge, "helper columns," or separate sheets to manually capture historical data snapshots. No Native History Tracking: Standard charts only visualize current cell values. There is no simple way to plot "what…